AD 2000-05-20
Registered aircraft · 736
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-05-20')
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-05-20')
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-05-20') 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-05-20') 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.
N313PJRpc Aviation LLC · Fayetteville, ARN313STIota Aviation LLC · Bloomfield Hills, MIN314SJHrm Aviation LLC · Chesterfield, MON315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315SCInternational Skychase Corp · Alachua, FLN316GBWellsprings Aviation LLC · Winston Salem, NCN317DTN42nh LLC · Oklahoma City, OKN317MNext Level Marine LLC · Mount Pleasant, TXN317MLMds Falcon LLC · Kittanning, PAN319CFOcean Drive Bulgaria Corp · Wilmington, DEN320GWSky Wheeels LLC · Prince Frederick, MDN321AJM Hixson Aviation LLC · Denton, TXN321AKSnails Pace Aviation LLC · New York, NYN321EJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN322FJRegistered aircraftN322RRNion LLC · New Century, KSN324SLAp Aviation LLC · Troy, VAN325EXFalcon 325 LLC · Fort Pierce, FLN325GMRegistration Pending · Salt Lake City, UTRegistration pendingN328JLLamon Aviation LLC · Boise, IDN330KJet Sense Aviation Aircraft Holdings Corp · Lake Zurich, ILN333DLD&S Aircraft LLC · Chicago, ILN333KEFalconmitch Inc · Sulphur Springs, TXN345KMJdr Management LLC · Boca Raton, FLN346EXWebair LLC · Warrenton, VAN34TJAbove The Rest Aircraft Services LLC · Midlothian, TXN356LGRegistered aircraftN35CDCoastal Development Group LLC · Boca Grande, FLFirst renewal noticeN35KVMit Oregon LLC · Portland, ORN360DMMaund Doug · Austin, TXN360SMChowdhury Aviation LLC · New York, NYN361DDWeco West LLC · Catarina, TXN361KBpcp Falcon N361k LLC · Wilmington, DEN362PTN378c LLC · Parker, CON364AEHayden Gray LLC · Dallas, TXN365TX235jb LLC · Lewes, DEN368MBAffiliated Investments LLC · Auburn Hills, MIN36EPJsm At Falcon II LLC · Piscataway, NJN3712CF900ex LLC · Minneapolis, MNN373RRM10 LLC · Rolling Meadows, ILN373RSKalamazoo Group II LLC · Kalamazoo, MIN37MDTriangle Aviation LLC · Dover, DEN37WXCsc Delaware Trust Co Trustee · Wilmington, DEN380CJSkyview LLC · Wilmington, DEN382KUMaverick Aire LLC · New Castle, CON383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN388BBPw Transport LLC · Lafayette, LAN38TVLs Mobile LLC · Weatherford, TXN395HEBillron LLC · Houston, TX
Back to AD 2000-05-20