AD 2000-11-03
Registered aircraft · 677
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-11-03')
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-11-03')
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-11-03') 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-11-03') 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.
N283SADodson International Parts Inc · Rantoul, KSN285KKHaystack 204 LLC · Portland, ORN286CXPinnacle Assurance LLC · Tampa, FLN286MJHc Logistics LLC · Chicago, ILN288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28DCMbogo Energy LLC · Boerne, TXN291BBattelle Memorial Institute · Columbus, OHN291MJTequila Mockingbird LLC · New York, NYN298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN299FGTvpx Trust Co LLC Trustee · North Salt Lake, UTN299PRMeregrass Inc · Dublin, TXN29BBattelle Memorial Institute · Columbus, OHN2NLCenturion Investments Inc · Chesterfield, MON301AFAir4 Aviation LLC · Houston, TXN304KSonic Automotive Inc · Charlotte, NCN306BHSdy Leasing LLC · Waterford, MIN306SHN306sh LLC · Chicago, ILN30HQLearjet Inc · Wichita, KSN310ZAZair Force One LLC · Mendenhall, MSN311BPWls Enterprise LLC · Portland, ORN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraftN313JLJnl Equipment Leasing LLC · Camden, DEN313PJRpc Aviation LLC · Fayetteville, ARN313STIota Aviation LLC · Bloomfield Hills, MIN314SJHrm Aviation LLC · Chesterfield, MON315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315SCInternational Skychase Corp · Alachua, FLN317DTN42nh LLC · Oklahoma City, OKN317MNext Level Marine LLC · Mount Pleasant, TXN317MLMds Falcon LLC · Kittanning, PAN319CFOcean Drive Bulgaria Corp · Wilmington, DEN321AJM 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, ILN345KMJdr Management LLC · Boca Raton, FLN346EXWebair LLC · Warrenton, VAN356LGRegistered aircraftN35KVMit Oregon LLC · Portland, ORN360DMMaund Doug · Austin, TXN360SMChowdhury Aviation LLC · New York, NYN361DDWeco West LLC · Catarina, TX
Back to AD 2000-11-03