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.
N4793FCitizen Air LLC · Port Angeles, WAN4793JSheco Inc · Aloha, ORN4793LWhitley Carol E · Kingwood, TXN4793SArkansas Pilots For Christ Inc · Paragould, ARN47941Engineering Forensics Inc · Glen Burnie, MDN47943Louiewex Corp · Dover, DEN4794FGet Out Aviation LLC · Palmer, AKN4794LFerraro Henrik L · Grand Island, NYN4794MSky Inc · Council Bluffs, IAN4794YAir Kraft Spraying Inc · Timber Lake, SDN47953Mountain Aviation Associates LLC · Midland, TXN47954Jennings James A · Fredericktown, OHN47955Southeastern Minnesota Flying Club Inc · Rochester, MNN4795CPrecision Design Inc · Wilmington, DEN4795DStemprok Roman · Corsicana, TXN4795FClark Joseph D · Kilgore, TXN4795LN383j LLC · Henderson, NVN4795QHinkle Airspray Inc · Cavalier, NDN4795TCammack Van R Jr · Willow Park, TXN4795UParker Omalley Corp · Chatham, NYN4795YPiper 4795y Aviation Services LLC · Colorado Springs, CON47965Reid Brian M · Boise, IDN47968Grimes Mike · Yukon, OKN47969Thomason Eric A · Georgetown, TXN4796AThompson Muriel K · Eagle Pass, TXN4796BHough Kenneth R · New Gloucester, MEN4796CHubbard Mark A · Wilmington, DEN4796GFranconia Soaring Association · Franconia, NHN4796K96k LLC · Cave Creek, AZN4796MN4796m LLC · Norridge, ILN4796NCessna N4796n LLC · Shreveport, LAN4796QNeufield Daniel · Brea, CAN4796VPittman Robert · Ocala, FLN47971Five X Five Flight Inc · The Woodlands, TXN4797MRegistration Pending · Satellite Beach, FLRegistration pendingN4797SSmith Matthew · Seattle, WAN4797UPhilbrick Rodney C DBA · Bishop, CAN47981Sabetha Flyers Inc · Sabetha, KSN4798BRegistered aircraftN4798CKjv Aviation Inc · Brentwood, CAN4798EClark Robert · Junction City, KSN4798KAmerican Diversified Services LLC · Marietta, GAN4798LThompson Michael · Stacy, MNN4798PShepherd Mike · Amarillo, TXN4798SEller Donald B · Palmer, AKN4798THrv Holdings LLC · Camp Hill, PAN4799CFlying Horse LLC · Missoula, MTN4799DDressen Donald L · Fruitland, IDN4799NLobb David C · Fort Myers, FLN4799PPlayer Dennis · Union Bridge, MD
Back to AD 2007-04-19 R1