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.
N575TAarow Aircraft Leasing LLC · Mcminnville, ORN575TDDahl Russell · Nashua, MTN575WKap Air LLC · Canton, OHN575WTDanemann Mark · Taos, NMN575YSilverhawk Aviation Academy LLC · Caldwell, IDN576Madera County Aircrafters Inc · Madera, CAN5760BAbbott Jay D · Rocky Mount, VAN5760DCrow Jack R · Bethel, AKN5760FG & D Leasing LLC · Tempe, AZN5760PLoughlin Robert J · Midland, TXN5760QHill Jonathan Troy · Taylorsville, KYN57617Elijah Air LLC · Bethel, AKN5761BTerry Canales Attorney At Law Pllc · Edinburg, TXN5761FNoriega Vanessa · Miami, FLN5761GNelson Ken · Caledonia, WIN57628Ridder Thomas · Leoti, KSN57629Hauf Daniel R · Jack, ALN5762APort Michael J · Twisp, WAN5762BAssociated Aircraft LLC · San Diego, CAN5762DNavar Thomas R · El Paso, TXN5762GBrown Patrick T Trustee · Osceola, WIN5762JJonesco Acquisitions LLC · Bixby, OKN5762KBagwell Jason R · Garner, NCN5762MNewby Aviation LLC · Pingree Grove, ILN5762QCross Brian K · Winters, CAN5762UYoung Robert C · Redmond, WAN57634Dye David V Trustee · Wasilla, AKN57635Robertson Trevor W · Spokane, WAN5763EVilla Rafael O · Miami, FLN5763FSugarloaf Air LLC · Harrison, ARN5763JLemons Brooks D · Visalia, CAN5763KNnamsu Enterprises LLC · Walnut Creek, CAN5763MStan Hill Aviation LLC · Waterford, MIN5763QMach 1 Air Services LLC · Los Angeles, CAN5763YLane Phillip C · Peru, INN57640Kramer Alex H · Louisville, KYN57641Bruch Zweit F · Whitewood, SDN57645Williams Shelia H · Headland, ALN57649Jagers Ed Dean · Lamar, CON5764DKoelsch Wayne M · Anchorage, AKN5764FRegistration Pending · Monticello, GARegistration pendingN5764HSleepytime Pllc · Eagle, IDN5764JLevy Laurent · Quakertown, PAN5764KDevine Robert L · Condon, ORN5764QJas Aircraft LLC · Summerland Key, FLN5764USlingsby Scott D Trustee · Francestown, NHN57651Maxeiner Kenneth · Lake Charles, LAN57654Mclaughlin John R · Moravia, NYN57656Haan Arthur G II · Indianapolis, INN57657Beitel Theodore C · Higden, AR
Back to AD 2007-04-19 R1