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.
N4200YTexas Red Bird LLC · Palo Pinto, TXN42016Roush Everett Wayne · Forsyth, GAN4201BNrnc LLC · Camden, DEN4201CFlying 4 LLC · Whiteville, TNN4201HWattenbarger Jay K · Fairbanks, AKN4201JYoerg Keith W · Culver City, CAN4201LSuverkrup Mark · Columbus, INN4201QReeve Ryan · Hurricane, UTN4201UEclipse Air LLC · Versailles, MON4201XWilson Daniel L · Sparta, MIN4201ZBennett Ruth B Trustee · Vancouver, WAN42020Brewster Matthew L · Chico, CAN42024White Wings Air Inc · Jacksonville, FLN42025Stokes Clive V · Gilbert, AZN42026Bains Jordan John W · Anchorage, AKN42027Dehart Dee Y · Payson, UTN4202JParker Aviation LLC · Camdenton, MON4202LAa-Aero LLC · Fairfield, NJN4202PWells John · Eugene, ORN4202QWings Over Texas Holdings LLC · Denton, TXN4202TSexton Ronnie K · Clarksville, ARN4202XIzzy Air LLC · Madison, WIN4202YAll Sports Aviation LLC · Cocolalla, IDN4202ZPiatt Matthew D · Wasilla, AKN42033State Of Alaska · Anchorage, AKN42035Paulsen Hans J · Cedartown, GAN42036Murphy Steven R · Aguila, AZN4203ABas Part Sales LLC · Greeley, CON4203HIvy Mark A · Anchorage, AKN4203PHillsboro Aero Academy LLC · Hillsboro, ORN4203QWings Over Texas Holdings LLC · Denton, TXN4203SWright John D · Richmond, TXN4203XNaples LLC · Mound City, MON4203ZLongboat Key Aviation LLC · Wooster, OHN42041Armenia John Robert · Land O Lakes, FLN42042N1622f LLC · Grand Prairie, TXN42044Van Beusekom Brian T · Loretto, MNN42045Jones Daryn W Trustee · Sumpter, ORN42049King Ronald E · Englewood, FLN4204BLieske William R · Lonsdale, MNN4204HAndrews Billy G · Wasilla, AKN4204TMorin Lucien A · San Antonio, TXN4204WWilbourne Danny L · Melbourne, FLN4204XAircraft Equipment Storage LLC · Duson, LAN4204YCharles Tim W · Caldwell, IDN4204ZKansas Air LLC · Linn, KSN42050Baum Thomas J · Kaufman, TXN42051Flying M Aviation Inc · Irondale, ALN42053Jewett Clinton Baxter Trustee · Colusa, CAN42055Klp Aeromotive LLC · Morriston, FL
Back to AD 2007-04-19 R1