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.
N5178HGage Scott M · Anchorage, AKN5178JSeven Eight Juliet LLC · Edmond, OKN5178LMinick And Son LLC · Beatrice, NEN5178RHampton Flying Services LLC · Portsmouth, NHN5178SG & M Aircraft Inc · Wheat Ridge, CON5178USoutheastern Oklahoma State University · Durant, OKN5178WMahoney Christopher P · Quakertown, PAN51790Tartock Russell L · Salisbury, NCN51793Lindsey Richard A · Richmond, TXN5179DBlack Daniel L · Spicewood, TXN5179GElie Jonathan · Hopewell Junction, NYN5179HFlight Time Builders Inc · Memphis, TNN5179PHangar 17 LLC · Sheridan, WYN5179UPower Flight LLC · Las Vegas, NVN5179VFairmont State University · Fairmont, WVN5179XKor Reese W · Piedmont, SDN517APa28 Aircraft LLC · Wilmington, DEN517AFAmeriflyers Of Texas Inc · Addison, TXN517ATHodgson Christopher John · Santa Cruz, CAN517BWWomer Blaine A · Hemet, CAN517CDPeker Lev M · Sylmar, CAN517DBBerry Bruce E · Louisville, TNN517DFForrest Michael D · Jasper, ALN517DJUrquhart Dan DBA · Fallon, NVN517DLDelta Leema Aviation LLC · Moncks Corner, SCN517GSPtag Flight Service LLC · Vidalia, GAN517HHart James A · Arlington, VAN517JGollus Daniel T · Lockport, NYN517JCProfessional Pilot Services · Appleton, WIN517JLSchmidt Robert G · Coppell, TXN517JPJones Jerry K · Syracuse, UTN517KBCorkins William J · Auburndale, FLN517KGRegistration Pending · Pittsburg, TXRegistration pendingN517KTAir-One Helicopters LLC · Lincoln Park, MIN517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeN517MAKilo Charlie Aeronautics LLC · Baton Rouge, LAN517MMMiller Jeremy M · Hazle Township, PAN517MPMorey Organization Inc · Wildwood, NJN517MSJewett John G · Ellensburg, WAN517PCAfrican Bible Colleges Inc · Karval, CON517PYYoung Millard Perrin · Raleigh, NCN517PZPapa Zulu LLC · Bend, ORN517RBRbc Holdings LLC · San Juan, PRN517RHRoyce Aviation LLC · Greenville, MSN517RLAndrews Mimi M · Hilltop Lakes, TXN517RSGraham Konner T · Pittsburg, TXN517SAHalo For Freedom Warrior Foundation · Willow Park, TXN517SCSpartan Education LLC · Tulsa, OKN517SHHelme Stanley B · Lodi, CAN517SMMcelvain Pete R · Iowa Park, TX
Back to AD 2007-04-19 R1