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.
N290CPCivil Air Patrol · Maxwell Afb, ALN290DFHoddenbach Jim · Woods Cross, UTN290DSNakel Inc · Elkton, SDN290FCRegistration Pending · Greenwood, MSRegistration pendingN290HADon'T Call Me Shirley LLC · Fort Myers, FLN290KCTsunami Skydivers Inc · Las Vegas, NVN290KZRowland Glen J · Monrovia, INN290MGGeorgia Aviation Authority · Eastman, GAN290NDChristiansen Aviation LLC · Wilmington, DEN290PEPhoenix East Aviation LLC · Daytona Beach, FLN290RMCxairco LLC · Yuma, AZN290SGinter Aviation LLC · Oakland, MDN290SHParker Helicopter LLC · Watsonville, CAN290TWChristiansen Aviation LLC · Wilmington, DEN290UOhio University · Albany, OHN290VGAlmy David W · Riverside, CAN29107Wrong Brothers Aviation LLC · Brighton, MIN2910LBurger Walter F III · Sugar Land, TXN2910XTallman Richard E · Lykens, PAN2911Dewinter Thomas A · Waunakee, WIN29110Sutton Aircraft Salvage LLC · Palmer, AKN29113Figueroa Angel Lara · Winfield, ALN29114Grey Goose LLC · Wasilla, AKN2911DPagano Ralph V · Cranbury, NJN2911EAsphaltresource.Com LLC · Schwenksville, PAN2911FRegistration Pending · Fayetteville, ARRegistration pendingN2911GOrtega Rolando J · Sanford, FLN2911XRobbins Donald V · Anchorage, AKN2911YBennett John M · Cameron, NCN29127Shivers William L Jr · Friday Harbor, WAN2912CMarshalee Arizona LLC · Tempe, AZN2912MHarriman Aviation LLC · Pearland, TXN2912PJackson Robert S · Gallatin, TNN2912TKrahling Jeffrey B · Redding, CAN2912XAmbler Carlos S · Mendota, ILN2912ZFord Charles D · Clifton, TNN29130Ernst Gregory R · Eagle Creek, ORN29131Kelly Alex · Arlington, VTN29138Allen Brent H · Mammoth Lakes, CAN2913ATruesdell Shannon · Stephenville, TXN2913CUnable Direct LLC · Kalispell, MTN2913EG & M Aircraft Inc · Wheat Ridge, CON2913TBlaine Christopher · Friday Harbor, WAN2913UAircraft Guaranty Corp Trustee · Oklahoma City, OKN29142Hall Darryl Wayne II · Wasilla, AKN2914AAvier LLC · Beverly, MAN2914BWhite And Blue Wings LLC · Oakland Park, FLN2914CSterkel Jared · Anchorage, AKN2914FHarris Zadok · Upland, CAN2914GSchubert Matthew · Belleair Beach, FL
Back to AD 2007-04-19 R1