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.
N5243RDraco Flight School Inc · Chino, CAN5243WFalcon Air LLC · Casper, WYN5243XMcclung Aerial Spraying Inc · Big Springs, NEN52440Hap'S Air Inc · Ames, IAN52441Christiansen Aviation LLC · Wilmington, DEN52443182-52443 LLC · Queen Creek, AZN52447Msc Services Inc · Hugo, OKN52448Haman Peter A · Douglas, WYN5244DMalnarick Kyce S · Anchorage, AKN5244EOpal Aviation LLC · Athens, GAN5244GMcmahan William K · Sandy Valley, NVN5244LGarman Daniel L · Burr Oak, KSN5244NCongressional Flying Club Inc · Gaithersburg, MDN5244RClauson Ed P · Charlestown, RIN5244URoberts Todd · Friday Harbor, WAN5244VKnucklehead Aviation LLC · Cedar City, UTN5244XFrantz William T · Wasilla, AKN5244ZRobinson Levi B · Anchorage, AKN52450Vandelay Investment Group LLC · Northbrook, ILN52454Clemens Kayleen · Arnold, CAN52458Eightball Air LLC · Spokane, WAN52459Noonan Joseph E Jr · Northport, MEN5245CN5245c LLC · Sequim, WAN5245JNuzzo Christian Larsen · Locust Grove, GAN5245KPerun Av LLC · Cliffside Park, NJN5245VMarianas Air Transfer Inc · Saipan, MPN5245WSwartzfager Lee C · Corry, PAN5245XPlane Fixer LLC · Ball Ground, GAN52466Stanley Louis J · Onaway, MIN5246LSmithson Thomas E · Franklin, TNN5246MFlorida Aviation Career Training Inc · Saint Augustine, FLN5246PYoyodyne Group Inc · Wilmington, DEN5246UMize Helicipter LLC · Edmond, OKN5246WScovil Jarin K · Laramie, WYN52473American Patrols Inc · Midland, TXN5247RHarbour Aviation LLC · Weatherford, TXN5247TTevik Michael A · Provo, UTN52483Walsh Air Enterprises · Sugar Land, TXN52487Johnson Thomas W · Westminster, MDN5248EColorado Skywagon LLC · Kiowa, CON5248PKnox Edward R · Gulfport, MSN5248TDopfel Sierra M · Udall, KSN5248UStephens Robert Z · Missoula, MTN5248WBalfa Joshua · Lumberton, TXN52499Zu Fliegen LLC · Las Vegas, NVN5249ABrentco Aerial Patrol Inc · Canton, OHN5249CDavis Douglas L DBA · Everson, WAN5249DQuicksilver Skycraft LLC · Langley, WAN5249EAlexandria Aviation Inc · Alexandria, MNN5249JWhitgo LLC · Lucas, TX
Back to AD 2007-04-19 R1