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.
N55416Cox David S · Elizabethtown, KYN55419Kinneberg Russell · Plymouth, MNN5541MDistrict School Board Of Pasco County · Land O Lakes, FLFirst renewal noticeN5541URegistered aircraftN5541WKauffman Duane N · Sarasota, FLN55420M A R S Aircraft Leasing LLC · Williamsburg, VAN55421Burton Tucker · Moberly, MON55422Boardman Thomas M · Greenwich, NYN55423Prescott Flying Club Inc · South Saint Paul, MNN55424Delgado LLC · Brandon, VTN55428Flight Gear Aviation LLC · Pickerington, OHN5542BSkydive Coolidge Inc · Tempe, AZN5542FColtman Graham E · Colleyville, TXN5542NRegistration Pending · Denver, CORegistration pendingN5542WAdvanced Airplanes Associates Inc · Keller, TXN55433Thrasher Aviation LLC · Bartonsville, PAN5543ASelf Defense Of New England LLC DBA · Bedford, NHN5543BSvetlik Ludvik J · Victoria, TXN5543EMedina Kevin S · Glendale, CAN5543FPantelias George · Astoria, NYN5543TTrinidad Flyers LLC · Fort Meade, MDN5543UAckerman Richard K · Ponce De Leon, FLN5543WTerpe Roberto Palomera · Sedro Woolley, WAN55441Airide Enterprise LLC · Dixon, MON55449Syracuse Flight School Inc · Syracuse, NYN5544KZollars Thomas B · Dallas, TXN5544NSkydive Co · Fairburn, GAN5544SLobitz James R Co Trustee · Oak Park, CAN5544TPercario Joseph · Warren, NJN5544WMatlack Mark R · Saint Bonifacius, MNN55450Conway Global LLC · Groom, TXN55452Schroeder William L · Sarasota, FLN55457Legend Air Lease LLC · Hurricane, UTN55458Challenger LLC · Amston, CTN5545AWhelan Peter A · Kettering, OHN5545BLundsted Andrew S · Taylor Falls, MNN5545DPartlow Lee · Granbury, TXN5545JMouat Michael Wayne · Hemet, CAN5545KSchroder Bernd · Brownsville, CAN5545LRegistered aircraftN5545MMata Brian J · Sacramento, CAN5545PVouk Frank E · Firth, IDN5545QVan Wagner Paul A · Waterford, PAN5545SLareve Air LLC · Bloomfield, MIN5545TMoody Bible Institute Of Chicago · Spokane, WAN5545UHewitt Robert J · Ringwood, NJN5546Forster Sebastian Alexander · Elberta, ALN55460Nish Aviation LLC · Concord, NCN55462Riverside Pilots Inc · Riverside, CAN5546BHeczko Eric M · Longmont, CO
Back to AD 2007-04-19 R1