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.
N325TTSuperior Flying Service LLC · Superior, WIN325ZLipovsky Kevin C · Commerce Township, MIN3260FGilbert Aviation Inc · Wilmington, DEN3260SAbner Aviation LLC · Advance, NCN3260YOneal Gary · Springdale, ARN3261CHeyman Steven · San Mateo, CAN3261DCastorina John Salvatore · Anthem, AZN3261SBig Island Gravity LLC · Kapaau, HIN32624Rio Aviation LLC · Wilmington, DEN3262SIlair LLC · Manassas, VAN3262XDns Aviation LLC · Fulton, CAN32631Grewell Dean R · Waukee, IAN3263SBynum Albert L · Gadsden, ALN3264QWilton William H · Kailua Kona, HIN3264XDesert Cat Aviation LLC · Tempe, AZN3265DMiller Matthew S · Washougal, WAN3265SZehntner David R · Labelle, FLN3265UPreissler Daniel E · Giltner, NEN3266UVingers Michael T · Dellwood, MNN3266XRegistered aircraftN3267DDavidson Danny F · Anchorage, AKN3268QSuperior Food Distributors LLC · Naples, FLN3268SSquier Mark R · Lake Dallas, TXN3269HEom LLC · Little Rock, ARN326AKN326ak LLC · Georgetown, DEN326CDOshoot Inc · Seabrook Beach, NHN326CMElemental Aviation Lc · Wichita, KSN326CPCirrus-2-Own LLC · Bellaire, TXN326DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN326FWWilliam Keith Stockman · Port Orange, FLN326KB4 Wingmen LLC · Sandy, UTN326LHPhelps Michael Scott · Franktown, CON326NWLandon Aviation LLC · Loganville, GAN326PTJt Aero LLC · Covington, GAN326SCuruchet Shay · Kaycee, WYN326SBAlpha Aviation LLC · Rancho Cordova, CAN326SRCharlie Tango Aviation LLC · Miami, FLN326TJBarnett John M · Fredericksburg, TXN326TKClark Shawn B · Fairhope, ALN326WRRoquemore William A Jr · Lakeland, GAN326ZMacdonald Daniel H · Kissimmee, FLN3270DMcbride Robert W Jr · Cedar Park, TXN3270JBerry Matthew G · Creedmoor, NCN3270RMotorman Of America Corp · Wilmington, DEN3270UScott Brian W · Sagle, IDN3271GPettit James P · Newport, VAN3271UDallas Avionics Inc · Dallas, TXN3271XCoastal Defense Inc · Mill Hall, PAN3271YWoodbury Ivan D · Bowling Green, OHN3272DTesk Aviation LLC · Steele, MO
Back to AD 2000-23-21