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.
N5262YLead Turn Aviation LLC · Ogden, UTN52635Allard Michael · Penrose, CON5263BFerland Erik · Everett, MAN5263GWarhawk Air Museum · Nampa, IDN5263LRjl Aero Inc · Valparaiso, INN5263VMccullough James M · Monte Vista, CON5263WCjco Holdings LLC · Venus, TXN5264CCullum Transportation LLC · North Charleston, SCN5264DPironti Bennett D · Long Valley, NJN5264GMorris Thomas Lee · Sonoma, CAN5264JBrowne Bryan C · Allen, TXN5264KRmg Aviation LLC · Newark, DEN5264PBohmer James F · Tulsa, OKN5264WGray Donald B Trustee · Houston, TXN5264XTank David M · Cambridge, OHN52654Jin Jin Aviation LLC · Anchorage, AKN5265CWorkman Aircraft Co Inc · Largo, FLN5265DFly 172rg LLC · Peoria, AZN5265ETree Top Flying Service Inc · Clarksville, TNN5265JSouthern Machine And Steel Inc · Fort Myers, FLN5265RMoss Hill Airport Inc · Kinston, NCN5265WDwight Marketing Corporation · Caldwell, KSN5265XSwanton Peter K · Willits, CAN5266ACire Advertising Inc · Norman, OKN5266DColemanation Investments LLC · Naperville, ILN5266ENatchez Flight Training LLC · Natchez, MSN5266KCorsicana Aviation Training Services LLC · Corsicana, TXN5266SFogle Cooper · Mooresville, NCN5266UN5266u LLC · Brookfield, ILN5266WMichigan Sport Aviators Inc · Midland, MIN5266XKrabbenhoft J F · Amenia, NDN52671Carver Aero LLC · Muscatine, IAN52674Miller Glenn E Trustee · Albany, ORN52677Spencer Joseph T Jr · Felton, CAN52678Land And Sea Aviation Alaska LLC · Anchorage, AKN5267EBrudelie Alan C · Lewisville, MNN5267HNichani Nikhil Deepak · Livingston, NJN5267LBlasi Aviation LLC · Valley Center, KSN5267PCarter Jeffrey Lee · Cameron Park, CAN5267RCastlegate Corp · Monee, ILFirst renewal noticeN5267SAviation Psych LLC · Neptune Beach, FLN5267VN5267v LLC · Northbrook, ILN5267XShelden Seth · Palmer, AKN5267YCkb Management LLC · Fayetteville, ARN5268Evans Eric A · Saint Peter, MNN52681Clough Robert · Woodinville, WAN52683Cobb John Mark · Fayetteville, TNN52685Glidewell Aviation Inc · Parkland, FLN52687Abby Enterprises LLC · Plantsville, CTN52689Dyberg Mike DBA · Mount Vernon, WA
Back to AD 2007-04-19 R1