AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N8824TKotek Nicholas · Meridian, IDN8826TShapiro Irwin H · Aventura, FLN882CPCivil Air Patrol · Maxwell Afb, ALN882DBBerland Donald B · Lone Tree, CON882FCFlying C Aviation Inc · Searcy, ARN882LBArizona Flyers Club Inc · Tucson, AZN882QHowell Andrew · Pinedale, WYN882SPRegistration Pending · Santa Fe, NMRegistration pending, canceledN8830THotrod Aviation LLC · Springdale, ARN8831TPacific North Hunters LLC · Kodiak, AKN8832TDickson Charles F · Ponte Vedra Beach, FLN8833XGrommet Michael J · Cascade, IDN8834TCzechowicz Nicholas B · Anchorage, AKN8834XRegistration Pending · Shawnee, OKRegistration pendingN8835XBechtel Jerold L · Snover, MIN8837TSimon Jevon D · Buckley, WAN8837XRichards Kevin J · Magnolia, TXN8838XAdventist World Aviation Inc · Wilson, NCN8839TKansas Farm And Ranch Inc · Seneca, KSN8839XAlexander Ray J · Battle Ground, WAN883CPCivil Air Patrol · Maxwell Afb, ALN883DDKelly David C II · Roseville, CAN8840TNelson William J · Hamilton, MTN8840XSb Enterprise LLC · Marshall, TXN8841XAngelone Inc · Elkhart, INN8842TMcnamee Michael P · Anthony, NMN8843TDiscovery Medical Research LLC · Kearney, NEN8843XDavis James S · Reno, NVN8844GNorthside Logistics And Automotive Inc · Dardanelle, ARN8844XMangum Larry M · Morristown, TNN8845KVan Bortel Aircraft Inc · Arlington, TXN8845THeaton James D · Cuba, MON8845XByerly Charles W · Joliet, MTN8846TN8846t LLC · Canyon, TXN8848THawkins Donald M · Borrego Springs, CAN8848XLevesque Michael C · Hampden, MEN8849XCopper River Airmotive LLC · Copper Center, AKN884CPCivil Air Patrol · Maxwell Afb, ALN8850TAmalong Timothy M · Tucson, AZN8850XBossola Raymond L · Suffolk, VAN8853XSnflk Leasing LLC · Andrews, TXN8854TMcgillivray Sean P · Grants Pass, ORN8854XSuper Skylane LLC · Dewey, AZN8855THolm Brian N · Buckley, WAN8857GUp And Away LLC · Seymour, TNN8857XBlanton Robert D · Wichita, KSN8858TGranger Bryce W · Ravenna, OHN8858XGordon Jeffrey · Indianapolis, INN8859TBooth Jesse R · Alamosa, CON885CEOwens John · Camden Point, MO
Back to AD 84-10-01 R1