AD 2000-23-21
Registered aircraft · 47,138
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-23-21')
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-23-21')
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-23-21') 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-23-21') 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.
N281CPJust Plane Insane LLC · Missouri City, TXN281DSBoughton Kyle · Mckinleyville, CAN281JPPrince Jeffrey S · Mckinney, TXN281MFFisher Robert · Durham, NCN281MGCirrus Design Corp · Duluth, MNN281PBMartin Robert F Jr · Fort Deposit, ALN281RWalker Lawrence J · Haymarket, VAN281RCCavett Richard A · Enderlin, NDN281RMHolthaus Craig J · Canton, ILN281STucker Daniel · Weatherford, TXN281SLCurly Aviation LLC · Atlanta, GAN281SRLawyers Real Estate Services LLC · Hondo, NMN281SVOlson Fred · Harrison, ARN281TMalerba David · Morrison, CON281TBJorgensen Carl · Boerne, TXN281UDStanley David Wayne · Burleson, TXN281VBarry Larry M · Woodbine, IAN282Sh1p Holdings LLC · Wichita, KSN28201Viking 28201 LLC · El Dorado Hills, CAN28208Registered aircraftAssigned, pending cancellationN2820BChildress Kenneth W · Longview, TXN2820RHutter Karl G · Reno, NVN2821ALewton John E · Belgrade, MTN2821K4608 Vista LLC · Fort Lauderdale, FLN2821QHattan Richard A Trustee · Fairbanks, AKN2821RNielson David L Trustee · Anchorage, AKN2822MWendt Robert R · Sedona, AZN2823AMckinney Eric S · Hamersville, OHN2824AStrode Lawrence W · Naknek, AKN2824MDodson International Parts Inc · Rantoul, KSN2824WBrown Logistics LLC · Auburn, WAN2825FStephens Jeffrey G · Gig Harbor, WAN2825KHigh Flying Club Inc · Fort Wayne, INN2825ROjeda Holdings LLC · Gainesville, GAN2825XJames Ray Inc · Twin Falls, IDN2825YSalva Kenneth J · Shingle Springs, CAN2826AConfer Gary R · Washougal, WAN2827NN714dd LLC · Pembroke Pines, FLN2827TRegan Keith M · Torrance, CAN2828ALatham Cory D · Great Bend, KSN2828FSmiley Neil J Trustee · Lake Havasu City, AZN2828KStephens Mark Edwin Trustee · Morgan Hill, CAN2828LInverted LLC · Las Vegas, NVN2828YHooey Kevin M · Beaver Dams, NYN2829YN2829y LLC · Longmont, COFirst renewal noticeN282ATMoonraker Iixl LLC · Wilmington, DEN282CBWhisky Tango LLC · Hendersonville, TNN282CDAurora Partners LLC · Oregon City, ORN282CPWright Andrew T · Clyde, OHN282DJViva LLC · Dover, DE
Back to AD 2000-23-21