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.
N5249NRed Lodge Flying Club Inc · Red Lodge, MTN5249RHigh Exposure Inc · Wilmington, DEFirst renewal noticeN5249TTri-Angle Aviation LLC · Henderson, KYN524BLDouble Lazy H LLC · Delta, CON524BQHfaw LLC · Augusta, GAN524BSCarpenter Robert L · Alto, NMN524CAHyannis Air Service Inc DBA · Hyannis, MAN524CBTechnical Film Systems Inc · Camarillo, CAN524CDDriscoll Cindy M · Savannah, TNN524CPCivil Air Patrol · Maxwell Afb, ALN524CWCentral Washington University · Ellensburg, WAN524DKCrane Doug M · Ellisville, MON524DRRegistered aircraftN524EMD D Gross Aviation Ltd · Amherst, OHFirst renewal noticeN524ESDickinson Drew H · New Braunfels, TXN524FLMoore Bruce W · Aledo, TXN524GKbeh Hangar Flyers LLC · Bridgman, MIN524HGRhc1 LLC · Myrtle Beach, SCN524HRLoureiro David · Granbury, TXN524HSBonanza N524hs LLC · Salem, ORN524JASkyhawk Leasing LLC · Indianapolis, INN524JNFalley Patrick R · Encinitas, CAN524KWMorris Donald R · Carbondale, ILN524LVSchotanus Reed D · Daytona Beach, FLN524MFunny Penguin LLC · North Canton, OHN524MDStick N Rudder LLC · Kensington, NHN524MESmith Lester C Jr · Colleyville, TXN524MMAviation Trust Company LLC Trustee · Oklahoma City, OKN524NNielsen Marvin E Jr · Easton, MDN524NDPhoenix East Aviation LLC · Daytona Beach, FLN524PAm Utilities & Construction LLC · Palmhurst, TXN524PSOperchal Thomas · Marathon, FLN524PUMetro Aircraft Co · Bloomington, MNN524QBartel Christopher H DBA · Williamsburg, PAN524RKAustin Air Cruises LLC · Dripping Springs, TXN524RTN524rt LLC · Greensboro, NCN524SCSpartan Education LLC · Tulsa, OKN524SJBorup Cory H · Orem, UTN524TCHalbrook Gorden E · Fleming Island, FLN524TLMoroni Nanette Teresa DBA · Orlando, FLN525Alpine Aviation LLC · Oklahoma City, OKN52501Freedom Works Consulting LLC · Louisville, KYN52509Thibodeau Carl J · Conway, NHN5250DRyan Justin E · King Salmon, AKN5250LAcharya Jagat P · Powell Butte, ORN5250NCaturia James J · Hastings, MNN5250TMedlaw Aviation LLC · Temple, TXN5250WJones Austin B · Suwanee, GAN52516Christiansen Aviation LLC · Wilmington, DEN52519Northwestern Michigan College · Traverse City, MI
Back to AD 2007-04-19 R1