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.
N489CYW Morrison Consulting Group Inc · Aliso Viejo, CAN489ERMenefee Scott A · Los Banos, CAN489GBNorthland Hangars LLC · Anchorage, AKN489HPHigh Performance Aircraft LLC · El Cajon, CAN489JOrr Matthew W · Kirkland, WAN489JEChambless Mardre F II · Panama City, FLN489LARed Baron LLC · Middletown, DEN489MHendrix Danny J · Aledo, TXN489PWsi Southwest Inc · Cliff, NMN489RSViage LLC · Boston, MAN489RVBoyter Wayne · Winston, ORN489TWehinger Christopher L · Hebron, OHN489TJUnknown Media LLC · Cape Canaveral, FLN48ALHutchinson Scott · Missouri City, TXN48AMGwc Air LLC · Madison, ALN48ARGacey Inc Trustee · Wilmington, DEN48ASTheunissen Wilhelmus H · Oxnard, CAN48BGWhitfill Mark J · Crockett, TXN48BKKrebs Brian G · Hartland, WIN48BRField Christopher R · Kingston, TNN48BTMalone William · Mount Nebo, WVN48BWBroadmoor Bed And Breakfast LLC · Colorado Springs, CON48CCC Baron LLC · Lafayette, LAFirst renewal noticeN48CDSky Helicopters Inc · Desoto, TXN48CEEssential Aviation Llcregistered · Hickory, KYN48CLSharp Wade L · Asheville, NCN48CMR Stephen Smith Inc · Wichita, KSN48DFFuhrman Dennis M Trustee · Independence, ORN48DJVan Iwarden Tracy D · Vacaville, CAN48DXSomers Andrew · El Paso, TXN48EFVista Air Inc · Pacoima, CAN48ELRegistration Pending · Livermore, CARegistration pendingN48ERChess Group LLC · Minden, LAN48EWKucel Richard S · Dallas, TXFirst renewal noticeN48FCSoarmates Inc · Missoula, MTFirst renewal noticeN48FFWingsleasing LLC · Wichita, KSN48FHG-Stf LLC · Midland, TXN48GHYellowstone Aviation Inc · Jackson, WYN48HAFiack Daniel P · Sun Valley, IDN48HGJahn Glenn R · Torrance, CAN48HTTurner Robert E · Castro Valley, CAN48HYStruble Anne D · Springville, UTN48JAJahawk Leasing LLC · Sugar Grove, ILN48JGWulvik Frederik M · Wasilla, AKN48JHFlying O Consulting LLC · Hammon, OKN48JJTotten James C · Newark, NJN48JKKeahey Britt · Saint Joseph, LAN48JLPfister Gregory S · Naples, FLN48JWLee William L · Jonesborough, TNN48KBRydberg Lawrence · Albuquerque, NM
Back to AD 2007-04-19 R1