AD 95-08-06
Registered aircraft · 119
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:95-08-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-08-06')
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:95-08-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-08-06') 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.
N469RJDodson International Parts Inc · Rantoul, KSN47HWCelebration Tv America Inc · Houston, TXN489BMEd Santos & Associates LLC Trustee · Wilmington, DEN518RRMidas Air Corp · Wilmington, DEN521JKSale Reported · Beverly Hills, CASale reported, canceledN561PSTlc Aviation LLC · Bloomfield Hills, MIN564BRKaleidoscope Charter Services Corp · Kansas City, MON58BLHawker 800xp LLC · Fort Lauderdale, FLN591CFKmw Flight LLC · Wilmington, DEN606Sale Reported · La LagunitaSale reported, pending cancellationN609RBAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationN616WGForza Wings LLC · Laredo, TXN6200HTnr Aircraft Holdings LLC · Englewood, CON624MPLansing Community College · Mason, MIN65DLChestnut Northern Partners LLC · Farmington Hills, MIN664SCAircraft Holding Solutions LLC Trustee · Newark, DEN671MMKmwflight LLC · Wilmington, DEN671RRAircraft Fidelity Corp Trustee · Dover, DEN682DN682d LLC · Wilmington, DEN68ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN700RRDaxen Logistic LLC · Chino, CAN704FUK&A Advisors LLC Trustee · Wilmington, DEN717MTAircraft Holding Solutions LLC Trustee · Newark, DEN718HCAcme Leasing II LLC · Nashville, TNN718LFJet Geeks Aviation Maintenance Inc · Teterboro, NJN724GPJawad A Shah Md Pc · Flint, MIN728HHNevarez Julio · Brownsville, TXN732AADjcj LLC · Nashville, TNN7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN777EHMilligan 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, 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, MD
Back to AD 95-08-06