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.
N418CASkybus Inc · North Miami Beach, FLN422CSBusiness Jet Managers Inc · Canton, MIN43JRGlobal Avionics LLC · Downey, CAN442MSWd Aviation Group Inc · Atlanta, GAN457JAviation Leasing Group Inc · Wilmington, DEN45GDPacific Rim Management LLC · Middletown, DEN45KGAircraft Holding Solutions LLC · Newark, DEN469RJDodson International Parts Inc · Rantoul, KSN47HWCelebration Tv America Inc · Houston, TXN489BMEd Santos & Associates LLC Trustee · Wilmington, DEN509DMTeam Aero LLC · Shawnee, KSN511BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN515LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeN518RRMidas Air Corp · Wilmington, DEN520LR1489 LLC · New York, NYFirst renewal noticeN520SBBank Of Utah Trustee · Salt Lake City, UTN521JKSale Reported · Beverly Hills, CASale reported, canceledN524LRUsac Airways 693 LLC · Fort Lauderdale, FLN52SMWumac Inc · South Portland, MEN533LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeN541LRBank Of Utah Trustee · Salt Lake City, UTN544LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeN547LRAviation Dynamics LLC · Portland, MEFirst renewal noticeN548LRAviation Dynamics LLC · South Portland, MEFirst renewal noticeN561PSTlc Aviation LLC · Bloomfield Hills, MIN564BRKaleidoscope Charter Services Corp · Kansas City, MON567CLN567cl LLC · Dallas, TXN58BLHawker 800xp LLC · Fort Lauderdale, FLN591CFKmw Flight LLC · Wilmington, DEN600MVN767cj LLC · Williamsburg, VAN606Sale 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, DEN67WESkyview LLC · Wilmington, DEN682DN682d LLC · Wilmington, DEN68ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN700RRDaxen Logistic LLC · Chino, CAN704FUK&A Advisors LLC Trustee · Wilmington, DEN707HDEfs Aircraft Leasing LLC · North Highlands, CAN717MTAircraft 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, TX
Back to AD 2000-02-35