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.
N509EREmbry-Riddle Aeronautical University Inc · Prescott, AZN509FGMustang Sally Aviation LLC · Camden, SCN509GCN509gc LLC · Branford, CTN509HSArmstrong Helicopters LLC · Laredo, TXN509JMRegistered aircraftN509LMClobro Media LLC · North Palm Beach, FLN509MCCicerchi Michael P · Denver, CON509MMCorrales Ag Flight LLC · Othello, WAN509MSAhmed Asif · Canoga Park, CAN509NDPhoenix East Aviation LLC · Daytona Beach, FLN509PTailwindsbikelyft LLC · Hannibal, MON509PCRich Lucas Aircraft Sales LLC · Lincoln Park, NJN509PGLake Stories LLC · Crosslake, MNN509RRAlten Flight LLC · Northbrook, ILN509RSHalf Shell Aviation LLC · Highlands Ranch, CON509RWRegistered aircraftN509SMCompton Stephen · Kennewick, WAN509SPScandinavian Aviation Academy Inc · El Cajon, CAN509SWMeise Weston · Moses Lake, WAN509TAN509ta-Ln LLC · New Braunfels, TXN509TCPattys Plane LLC · Tampa, FLN509UAlba Leasing Services LLC · Scottsdale, AZN50AAOgonowski Kristine Staffeldt · Wasilla, AKN50ACRegistered aircraftN50AHBrass Jeffrey A · Ackley, IAN50AUDapp Eric M · Corvallis, ORN50AWLillian Aviation LLC · Cypress, TXN50AZBenson Aviation LLC · Mehoopany, PAN50BDGoodrich Gilbert Joseph · Katy, TXN50BGStilson Scott · Ivins, UTN50BTWade William T · Fairhope, ALN50BXAthena Aviation LLC · Greenville, SCN50CAllred & Associates Inc · Skaneateles, NYN50CABachmann Erik J · High Bridge, NJN50CBHughes Eugene F Jr · Butte, MTN50CGDixon Jack · Casa Grande, AZN50CHBaker Harold · Byrdstown, TNN50CLLopez Johnny · Henderson, NVN50CPAtkins Daniel E · Marlette, MIN50CSBoretsky Bryan F · Lolo, MTN50CTAyers Jeffrey D · Canandaigua, NYN50CXChristmas Candy · Angel Fire, NMN50DDQualitair LLC Trustee · MichelstadtN50DFCargille Joshua C · Kenosha, WIN50DMMiller Cory L · Winnsboro, TXN50DPRenkel Christopher P · Westlake, OHN50DTHarrell Ag Aviation LLC · Oak Grove, LAN50ECPremier Wireless LLC · Kalispell, MTN50EHSands Thomas · Columbia Falls, MTN50ERFisher-Smith Jotham · Soquel, CA
Back to AD 2007-04-19 R1