Registered aircraft · 72,007

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

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:87-10-06-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:87-10-06-R1') ORDER BY n_number

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N3249FRoberto Jeffrey M · Piscataway, NJBuilt 1967 · S/N 670042 N3249RTappan Scott M · Port Saint Lucie, FLS/N 32-7140049 N3249WMountain West Aviation LLC · Albuquerque, NMBuilt 1965 · S/N 32-67 N324ALauridsen Hans O · Scottsdale, AZFirst renewal noticeS/N 9962CC N324AKKeiser John T · Santa Fe, NMBuilt 2018 · S/N CC19-0041 N324BKing Ag Leasing Inc · Sudan, TXBuilt 2005 · S/N T20608526 N324BBN324bbjf Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 647 N324CFerris Ryan P · Rochester, NYBuilt 1999 · S/N 374-320-129 N324CSBrush Country Helicopters LLC · Laredo, TXBuilt 2013 · S/N 2321 N324DBDaugherty Warren F Jr · Jonestown, PABuilt 1956 · S/N 324 N324DHWood Thomas E · Sherrills Ford, NCBuilt 1979 · S/N AA5B1259 N324DNFluckey Craig · Plattsmouth, NEBuilt 2003 · S/N 80820-001 N324DSSpearing Dane R · Los Alamos, NMBuilt 1970 · S/N 32-40856 N324GIsle Air LLC · Danbury, CTBuilt 1995 · S/N 3246003 N324MARollings Hills Aviation Inc · Pelham, GABuilt 2002 · S/N 1330-2002 N324PATravaille Bernard W Trustee · Manteca, CABuilt 2001 · S/N 3257230 N324PTPlanedocs LLC · Spearfish, SDBuilt 2007 · S/N 40081 N324RPClear For Take Off LLC · Burlingame, CABuilt 2004 · S/N 18281422 N324RRCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1386-139 N324RTTorres Rafael · Levittown, PRBuilt 1966 · S/N 27-3210 N324RVAmsa Jet Crew Solutions LLC · Windermere, FLFirst renewal noticeBuilt 1998 · S/N 24895 N324SVDavis Kyle R · Colleyville, TXBuilt 1980 · S/N R18201609 N324TAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1980 · S/N 892 N324TSDes Moines Flying Club LLC · Indianola, IABuilt 1966 · S/N 32-841 N324WCSebastian Charles J · Baytown, TXBuilt 2020 · S/N 131-255B/256B-1379 N324XFontenot Ira Dean · Collierville, TNBuilt 1975 · S/N 300 N32500Fairfield Flying Service Inc · Fairfield, IAS/N 28-7525076 N32501Meives Mark J · Barneveld, WIS/N 28-7515171 N32505N83at LLC · Dover, DEBuilt 1974 · S/N 28-7505065 N32506Schuhler Louis A · Plainfield, ILBuilt 1974 · S/N 28-7505066 N32509Cherotation LLC · Guaynabo, PRBuilt 1974 · S/N 32-7540045 N3250FMantissa Corporation · Charlotte, NCBuilt 1967 · S/N 670043 N3250JHigh Mesa Aviation LLC · Naturita, COBuilt 1966 · S/N 15065950 N3250ZLawrence Grant Heath · Saratoga Springs, UTS/N 22-7198 N32512Williams Clarence D · Charleston, MOBuilt 1974 · S/N 32-7540048 N32514Summit Flight Academy LLC · Peculiar, MOS/N 28-7525075 N32518Lahmann Jason L · Tripoli, IABuilt 1974 · S/N 28-7515174 N32519Bachert Nicholas T · California, MDBuilt 2020 · S/N 41353 N3251FRegistered aircraftBuilt 1967 · S/N 670044 N3251GKrebs David A · Lubbock, TXBuilt 1980 · S/N 32R-8029044 N3251ZCopper River Airmotive LLC · Copper Center, AKBuilt 1959 · S/N 22-7199 N32521Proflite Of Alaska LLC · Fairbanks, AKS/N 28R-7535065 N32523Heeringa Consruction LLC · Queen Creek, AZBuilt 1974 · S/N 32-7540046 N32524Barth Tom L · Manhattan, KSBuilt 1974 · S/N 28R-7535067 N32525Willaford Gina T · Cape Coral, FLBuilt 1974 · S/N 28-7525078 N32526Cannon Adam H · Purcell, OKS/N 28-7525079 N3252FBubes Michael D · Cocoa, FLBuilt 1967 · S/N 670045 N3252PGodbout Kevin P · South Hadley, MABuilt 1957 · S/N 23-1197 N3252QArcher Inc · South Ozone Park, NYBuilt 1977 · S/N 28-7790446 N3252TFugfugosh Mahdi A · Castro Valley, CABuilt 1967 · S/N 17700552

Back to AD 87-10-06 R1