AD 2000-02-35
Registered aircraft · 150
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-02-35')
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-02-35')
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-02-35') 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-02-35') 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.
N730CJN730cj LLC · Williamsburg, VAN732AADjcj LLC · Nashville, TNN7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN770RGAir Mccormack LLC · Chicago, ILN777EHMilligan Michael Zachery · Reno, NVFirst renewal noticeN778RMAero Advantage Services Corp Trustee · Wilmington, DEN798PAJli Holdings Group Inc · Johns Island, SCN800AFJec Hawker LLC · Pflugerville, TXN800CJCdmr Pj LLC · Jackson, NJN800EGAircraft Trustee Services Inc Trustee · Dover, DEN800FJAstra Aircraft Holdings Corp · Wilmington, DEN800JMGreen Chair Productions Inc · Wichita Falls, TXN800PAVance And Priscilla Hinton LLC · New Braunfels, TXN800RGRm13 Air LLC · Wellington, FLN800SEDodson International Parts Inc · Rantoul, KSN800SVAircraft Fidelity Corp Trustee · Dover, DEN800VRCkv Express LLC · Minneapolis, MNN800WAKmwflight LLC · Wilmington, DEN800WDV1vr LLC · Wilmington, DEN800WHGsmh LLC · Daniel Island, SCN801LMGlobal Aircraft Solutions LLC Trustee · San Antonio, TXN801PJGovoa LLC · Miami Beach, FLN801RMBlue Skies Hawker LLC · Canton, MIN802WJXoom Enterprises LLC · Sunny Isles Beach, FLN803RKAircraft Holding Solutions LLC Trustee · Newark, DEN810KBOrange Skies LLC · New Carrollton, MDN816JMFoxfire Aviation LLC · Henderson, NVN821MPLucas Aviation LLC · Fremont, MIN826GCMqe LLC · Missoula, MTN83MDFielding William · Delray Beach, FLN850SXN850sx LLC · Lewes, DEN854JCPuerto Rico International Airlines Inc · San Juan, PRN855MWMunguia Mario · Downey, CAN868WU868wu LLC · South Portland, MEN880LTHawker 1000 42-51 LLC · Pompano Beach, FLN884ABJetsteam Aviation Inc · Cheyenne, WYN8881JGdc Aviation LLC · Jacksonville, FLN8888HTexas Aircraft Parts Brokers LLC · Seguin, TXN900JTDbl Flight Services LLC · Dayton, OHN910CFNavi Aviation LLC · Dover, DEN910KSAircraft Holding Solutions LLC · Newark, DEN913SCAircraft Holding Solutions LLC · Newark, DEN914ECPacific Rim Management LLC · Downey, CAN918XZAircraft Holding Solutions LLC Trustee · Newark, DEN935HPrestige Jets Inc · Dover, DENon-citizen corporation, flight hours not reportedN944TBK&A Advisors LLC · Wilmington, DEN955DPN955dp LLC · Wilmington, DEN976SCAviation Resource Group Inc · Fort Lauderdale, FLN9793KDodson International Parts Inc · Rantoul, KSN982ECAlliance Air Parts Acquisitions Corp · Oklahoma City, OK
Back to AD 2000-02-35