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.
N3636YMorales Peter · Lake Worth, FLN3637CThree Seven Charlie LLC · Camp Hill, PAN3637PBlazek Troy L · Cottage Grove, MNN3637RGelinger Gary · Cape Carteret, NCN3637WStruck Dennis L · Spirit Lake, IAN3637ZFord Kristy M · Marianna, FLN36382Pallaziol Delia N · Vista, CAN36384Lisa Rocco J · Elkhart, INN36387Hlavin Mark S Trustee · Lakewood Ranch, FLN3638HQuantie Harold G · Locust Grove, OKN3638PSorrell Byron D · Warren, MIN3638QWinder Keven S · Castle Rock, CON3638RDukeman James C · Apex, NCN3638WCherokee Six LLC · Williamson, GAN36393Meriden Aviation Center LLC · Meriden, CTN36395Brittle Aviation LLC · Chapel Hill, NCN3639DOlah Michael J DBA · Mazomanie, WIN3639HBeatty Earl IV · Gambrills, MDN3639PJoseph Patrick S · Saint Charles, MON3639UWaltz Elizabeth · Grapevine, TXN3639WYoungpeter David L · Spencerville, OHN3639YMurphys Flying Service LLC · Quitman, GAN3639ZStahl Calvin D · Auburn, WAN363ACAig Aeronautics LLC · Guaynabo, PRN363BShoal Properties LLC · Bokeelia, FLN363BLElizabeth City State University · Elizabeth City, NCN363CKAviator Air Operations LLC · Grand Prairie, TXN363CPBarr Air Patrol LLC · Mesquite, TXN363CS3tr Aviation LLC · Longview, TXN363DSDonkers Dave · Nerstrand, MNN363FSMarlu Enterprises Inc · Foristell, MON363GCPorter David R · Dayton, OHN363JVRead Andrew R · Milwaukee, WIN363KRegistered aircraftN363KBTriple F LLC · Dixon, ILN363MBCohen Greg · Gaithersburg, MDN363MKNorth Star Aviation Inc · Mankato, MNN363RMankind Aviation LLC · Cincinnati, OHN363RJJordan Robert A · Avon Park, FLN363RMMash Kity J LLC · Grand Rapids, MIN363RSOgden Laurence B · Weaverville, NCN363RVRoberts David · Albuquerque, NMN363SCOcm Aviation LLC · Buckeye, AZN363SKKamasano LLC · Highland, CAN363SPOrange County Flight Center Inc · Santa Ana, CAN363T1800sky LLC · Henderson, KYN363TGGautier Thomas N III · Altadena, CAN363WDFas Aviation LLC · Southlake, TXN363ZN363z Flyers LLC · Lenexa, KSN36400Vlietstra Steven J · Hatley, WI
Back to AD 2007-04-19 R1