AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N56AMPeavy Michael J · Chico, CAN56BKoch & Koch Inc · Grass Valley, CAN56BEBirds Eye View Inc · Middletown, RIN56BGGuernsey Gibson R · Belen, NMN56BPCeballos Oscar Felipe · San Ysidro, CAN56BSHansen Nick K · Litchfield Park, AZN56BVEuroaviation Inc Trustee · KematenN56BWWnk Leasing LLC · Lewes, DEN56CCMichel David L · Pickens, SCN56CEWave Shack Acquisitions LLC · Lewes, DEN56CJSchmid Urs · Jupiter, FLN56CKThurber Mark C · Manchester, MDN56CMFamily Practice Associates LLC · Ulysses, KSN56CPBulldog Aviation LLC · Goodyear, AZN56CVVaughn Geoffrey · Brunswick, GAN56CWLaurel Aviation Inc · Decatur, ILN56DBBerger Dale · Bay Village, OHN56DCAero Services Lc · Woods Cross, UTN56DDMeier Perry S · Conroe, TXN56DEWaypoint Aviation Corp · San Jose, CAN56DGEagle East Aviation Inc · North Andover, MAN56DWReed John S · Wasilla, AKN56EB56 Eb Inc · Jacksonville, FLN56ECBpc Aviation LLC · Rosamond, CAN56EEStansfield Tod A · Elm Grove, WIN56EKQuailair LLC Trustee · MichelstadtN56EPSanders Flight Training Center Inc · Jasper, ALN56ERGsell Bruce Ward · Southampton, NJN56FAir Kings LLC · West Chester, PAN56FASilver Express Co DBA · Miami, FLN56FDDefibaugh Fred M · Chino Alley, AZN56GBCalhoun Keith A · Springville, TNN56GKMatan Kai LLC · West Hollywood, CAN56GLRainosek Kevin · Granbury, TXN56GTDonaldson Timothy A · Oklahoma City, OKN56GUIdagus N56gu LLC · Miami, FLN56HDouble D International LLC · Miami, FLN56HCFaire Ken · Mojave Valley, AZN56HEYork Philip S · Sedro Woolley, WAN56HJRobinson Douglas J · Dayton, NVN56HMBarrett Keith Alan · Anniston, ALN56HRStrachan Annmarie C · Overgaard, AZN56HYCipolli Robert J · Montgomery, MAN56JDDignan Charles N · Telluride, CON56JKStalp Ag Leasing LLC · Fremont, NEN56JLSea Air Inc · Wilmington, DEN56JSPoppy Wayne J · New London, WIFirst renewal noticeN56JUSurfield Ronald W · Leonardtown, MDN56KCCrawford William K · Ovilla, TXN56KMBudake LLC · Macon, GA
Back to AD 2007-04-19 R1