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.
N4293QKcsi Aerial Patrol Inc · Bakersfield, CAN4293YArcher N4293y LLC · Tulsa, OKN4293ZSuper Cub N4293z LLC · Creston, CAN42941Nistler Steve W · Helena, MTN42942Mott Plane LLC · Morning Sun, IAN42945Pollnow Dean M · West Bend, WIN42947N42947 LLC · Panama City, FLN42949Niemeyer Donald C DBA · Hobart, INN4294JWahner Rudolf M Jr Trustee · Aston, PAN4294NCoastal Aviation LLC · Virginia Beach, VAN4294QOptimized Aviation Services LLC · Huntington Station, NYN4294TSopwith Camel Flying Club LLC · Salt Lake City, UTN42951Tiedt Randy · Parkville, MON42955Brown Donald E Jr · Jonesboro, ARN42958Havasa Enterprises LLC · Sisters, ORN4295ANy Fighter Jets · Wilmington, DEN4295RGhost Riders Aoo LLC · Altoona, PAN4295VMcmahon Ian R · Locust Grove, GAN42967Brook Daniel L · Marshall, INN42968Jelinek Spencer T · Erie, CON4296HBogart Sean A · Anchorage, AKN4296NScholz Daniel Joseph · Mantorville, MNN4296PInvestair LLC · Conway, ARN4296QAirjohn LLC · Cheyenne, WYN4296SB J Air Inc · Wilmington, DEN4296ZSisk Michael Shaun · Steamboat Springs, CON42972Anderson Mike D · Mc Alpin, FLN42974Tracy Lanning Construction LLC · Westminster, SCN4297547q LLC · Eau Claire, WIN4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN4297HAirswiss Inc · Wilmington, DEN4297MInternational Air Services Inc Trustee · Carson City, NVN4297QCritchfield David P · Paradise, CAN4297ZAcadiana Cub LLC · Abbeville, LAN42980Friday Dale C · Santa Cruz, CAN42982Dassin Andre · Altadena, CAN42985Hall Jason · Iron Mountain, MIN42987Gman Air LLC · Clayton, MON4298LToon Corey A · Carthage, TXN4298QDarrach Todd I · Rhome, TXN4298YAir LLC · Fresno, CAN4298ZAugustine Ryan M · Talkeetna, AKN4299HCompton James D · Griffin, GAN4299PAllison Daniel H · Whittier, NCN4299ZKauffman Loren C · Anchor Point, AKN429ACRegistration Pending · Morris, ILRegistration pendingN429AFConcho Aviation LLC · Sterling City, TXN429AMAero Mark Inc · Idaho Falls, IDN429BJJohnston Richard Max Trustee · Sierra Madre, CAN429CDQualitair LLC Trustee · Michelstadt
Back to AD 2007-04-19 R1