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.
N440AAFms Bank · Fort Morgan, CON440AJRocky Mountain College · Billings, MTN440AKStrauss Craig R · Hicksville, NYN440BANo More Jump Seats LLC · Bowling Green, KYN440BBHead James M · Columbus, OHN440BETextron Aviation Inc · Wichita, KSN440BFWallschlaeger Dean A · Georgetown, TXFirst renewal noticeN440BPBreeze Scott W · Thompsons, TXN440CDN440cd LLC · Williamsburg, VAN440CKKeirs Christopher D · Tomball, TXN440DDeeble Kenneth M · Dayton, MTN440DBOdonnell Thomas E · Brookshire, TXN440DKCitation Companeros LLC · Seguin, TXN440DRDakota Rotors LLC · Custer, SDN440DWWheeler Daniel D · Moab, UTN440DZSouthern Aircraft Consultancy Inc Trustee · Casper, WYN440EJJsj Aviation LLC · Mesa, AZN440ERChristiansen Aviation LLC · Wilmington, DEN440FBock Jacqueline D · Sterling, AKN440FAA-Cent Aviation Inc · Jacksonville, FLN440FTAviation Express Inc · Greenville, WIN440GVon Pasecky Ronald · Gilbert, AZN440GCKaufmann Bryan · Lakeville, MNN440JPBernstein Robert L Trustee · La Jolla, CAN440KBJ3 Contracting Inc · Milton Freewater, ORN440LSale Reported · Clovis, CASale reportedN440LAParks David W · Ithaca, NYN440LLLast Larry A · Oshkosh, WIN440LWBig Dawg Air LLC · Ringgold, GAN440MKAtp Aircraft 8 LLC · Wilmington, DEN440MXSmalley Glen E · Kasilof, AKN440NDPars Avn Corp · Wilmington, DEN440PABird Acquisition LLC · Phoenix, AZN440QB&T Aviation LLC · Columbia, SCN440RHAirtrust LLC - 12 - Series 12 Trustee · Sheridan, WYN440SHNovember Alpha LLC · Dover, DEN440SUFutrell Kenneth R · New Smyrna Beach, FLN440TJs Aviation Group LLC · Sedona, AZN440TBJones Noah M · Powderly, TXN440TCTexas State Technical College · Waco, TXN440TKTim Kepp LLC · Point Pleasant, PAN440TTHarrison Tracee · San Juan, PRN440TWMartinez Azoulay · Reno, NVN440UBoard Of Regents Of The University Of Oklahoma · Norman, OKN440VBBracewell Enterprises LLC · Lewes, DEN440WAOw Aviation LLC · West Chester, PAN44104Reed Matthew · Lander, WYN44105Lyman Ashlee B · Delta, UTN44107Cilly Ajay V · East Brunswick, NJN4410EEkstrand Anders R Jr · Palmer, AK
Back to AD 2007-04-19 R1