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.
N5515NAronoff Raymond · Katy, TXN5515SGotay Ricardo M · Watertown, CTN5515VMt Aircraft LLC · Port Orange, FLN55160Davis Joseph S · Andalusia, ALN55163Jackson Donald W · Carthage, MSN55166Volando LLC · Columbia, MON55167Flyboys Nevada LLC · Henderson, NVN55169Jin Jin Aviation LLC · Anchorage, AKN5516CCarson Kirk · Dalhart, TXN5516FMoore Marcus · Auburn, ALN5516JRobarge Andrew Michael · Crown Point, INN5516SAtc Trucking Inc · Miami, FLN5516UHicks David A · Beaver Dam, WIN55173Dareing Chon · San Antonio, TXN55176Hall Davis · Mobile, ALN55177Saunders Ivan J · Margate, FLN55179Rick Aviation Inc · Newport News, VAN5517DTillman Fred L · Lakeland, FLN5517FMccarthy Mark C · Russellville, ARN5517JGiblin Daniel P · Loveland, OHN5517MBas Part Sales LLC · Greeley, CON5517QTrayhan Edward J · Schertz, TXN5517SRussell Charles B · Union City, TNN5517UKoegel John C · Flint, MIN5517VWest Bryan M · Heath, TXN5517ZTravnicek Sandy R · Bowie, TXN5518Campbell Larry L · Fort Mill, SCN55180Craig Warren J · Ellerbe, NCN55181Bluewater Airmotive Corp · Wilmington, DEN55182Sofla Sky Solutions LLC · Deerfield Beach, FLN55185Bailey Richard W · Auburn, ALN55187Aerospace Trust Management LLC Trustee · Wilmington, DEN5518ERomeo Charley LLC · Boulder, CON5518GChristiansen Aviation LLC · Wilmington, DEN5518JEbaugh Michael D · Port Saint Lucie, FLN5518KDiaz James F · Campbell, CAN5518TBlue Sky Group Inc · Wilmington, DEN5518UC1 Aviation LLC · New Orleans, LAN5518WChristiansen Aviation LLC · Wilmington, DEN55192Soodsma Thomas N · Vero Beach, FLN55197Bartlett Aviation LLC · Louisville, KYN5519ABiersack Alexander J · BerlinN5519BRaven Air LLC · Athol, IDN5519CKukeeza LLC · Williston, NDN5519GBalkema Jeff · Scotts, MIN5519JGoodwyn Thomas M · Las Vegas, NVN5519UBurlington Veterinary Systems LLC · Burlington, KSN5519VMercer Asa · Manderson, WYN551AJSo Fine Air LLC · Palm Beach Gardens, FLN551APCappe Investment Group LLC · Homestead, FL
Back to AD 2007-04-19 R1