AD 2000-08-13
Registered aircraft · 432
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-08-13')
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-08-13')
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-08-13') 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-08-13') 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.
N770ESElite Sales Leasing LLC · Miami, FLN770TDTango Delta LLC · Grand Rapids, MIN777QLMed Air LLC · Lawrenceville, GAN780BHVanlex Flight Services LLC · Omaha, NEN784CCXcel Jet Management Inc · Newark, DEN786CCPoema Ventures LLC · Chatsworth, CAN786HDHarmony Management LLC · Sugar Land, TXN787CHLj-45 LLC · Wilmington, DEN796JHGpc Aviation Investments LLC · Fresno, CAN799WWVarsity Equipment LLC · Beachwood, OHN7SNSevenson Environmental Services Inc · Niagara Falls, NYN800ABCheck Clearing House Aviation LLC · Glenwood Springs, CON801MMLiechty Aviation LLC · Lagrange, GAN802AKRa Aviation Holdings LLC · Prosper, TXN808WSouders Danny L · Broomfield, CON816FGN816fg LLC · Urbana, ILN816LJAlliance Aviation Group LLC · Wilmington, DEN818BDPoarch Swinbank Investments LLC · Houston, TXN820ATTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN823CAExtraordinaire Aviation II LLC · Fairfield, OHN823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN823HMCyprus Center Services LLC · Gilbert, AZN825CATwn Capital LLC · Newark, DEN826CALear Management LLC · Tulsa, OKN82JKPlane Crazy LLC · Addison, TXN840ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN840JMGwzi LLC · Dover, DEN842MBMed Air LLC · Lawrenceville, GAN853LTN853lt Aviation LLC · Bixby, OKN85GRGr Equipment Leasing LLC · Greenwood Village, CON868VBNw Holdings LLC · Saint Joseph, MON870ZPotomac Corp · Wheeling, ILN87SKSmm Aviation 1 LLC · Oklahoma City, OKN880CHEcho Acquisitions LLC · Dover, DEN881MJKalitta Charters LLC · Ypsilanti, MIN882CAPere Marquette Group LLC · Grand Rapids, MIN887SGN45ax LLC · Tulsa, OKN888DSAdams Aviation Services Inc Trustee · Wilmington, DEN889CAGracon Express LLC · Lafayette, CON8983DDodson International Parts Inc · Rantoul, KSN901HDN27ax LLC · Tulsa, OKN909MVXcel Jet Management Inc · Newark, DEN90BTB & G Aviation Inc · Miami, FLN90GSG & S Aviation II LLC · Jackson, MSN90XRInternational Aviation Technical Services Inc · Torrance, CAN916BDDillards Inc · Tunica, MSN917BDDillard'S Inc · Tunica, MSN917BERegistration Pending · Cottonwood Heights, UTRegistration pendingN918EGOmni Aircraft Maintenance LLC · Tulsa, OKN918LSSamson Energy Company LLC · Tulsa, OK
Back to AD 2000-08-13