AD 2000-03-09
Registered aircraft · 1,323
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:2000-03-09')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-03-09')
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:2000-03-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-03-09') 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.
N144KMKcc Av LLC · Fayetteville, ARN144XLCentury Air Conditioning Transportation LLC · Sugar Land, TXN145KKDodson International Parts Inc · Rantoul, KSN148JRDodson International Parts Inc · Rantoul, KSN14QSRegistered aircraftN150BLRca Air LLC · Conway, ARN150GPSteel Aircraft Leasing LLC · Saint Augustine, FLFirst renewal noticeN152JHSeaport Aviation Inc · Quincy, MAN153PMCeco Aviation LLC · Midland, TXN154JKRacd Holding LLC · Pembroke Pines, FLN155PTWaypoint Aviation LLC · Wilmington, DEN155RWExcel Holdings Inc · Wilmington, DEN156XLJ G Boswell Co · Pasadena, CAN157TFMeyers Aircraft Trading West LLC · Windermere, FLN157XLFrontenac Properties Inc · Chesterfield, MON158JSMae Aviation LLC · Dover, DEN158SKNokomis Airways LLC · Camden, DEN15JTSignalwave LLC · Ocala, FLN15MPMkam Aviation LLC · Sioux Falls, SDN15QSBaron Charter Service LLC · Oklahoma City, OKN15RNExecutive Jet A LLC · Danbury, CTN15SLCp Ultra LLC · Sacramento, CAN164RAJetway N164 LLC · Brooklyn, OHN165DSTextron Aviation Inc · Wichita, KSN166RDIsland Park Aviation LLC · Fargo, NDN166STGable S Corp · West Linn, ORN167JNJnf Aviation LLC · Pasadena, TXN168BGValle Aviation Inc · Nashville, GAN168GSG Delaplaine Enterprises LLC · Frederick, MDN169CRContinental Resources Inc · Baker, MTN16QSCavalier 2001 Holdings LLC · Oklahoma City, OKN174JSJr Simplot Co LLC · Boise, IDN176ALAllen Lund Co LLC · La Canada, CAN176DLFive In Five LLC · Dallas, TXN177EIntrepid Air LLC · Tuscaloosa, ALN177HNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN178JCOrchid Lane LLC · Portland, ORN178LCH512 Leasing LLC · Sandy, UTN178WGBetteravia Farms LLC · Santa Maria, CAN17ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN17EDExcel4 LLC · Carmel, INN17QSRegistered aircraftN17TXTriangle 5 Ranch LLC · Longview, TXN180BBailey Aviation LLC · Roswell, NMN180HLTrinity Capitol Leasing LLC · Fort Pierce, FLN181SGBiotechnologies LLC · Chippewa Falls, WIN1837STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1853Bounty Investments LLC · Fort Worth, TXN1865KCommerce Bank · Kansas City, MON1867MExcel Holdings LLC · Heber City, UT
Back to AD 2000-03-09