Registered aircraft · 5,075

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:84-19-03-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-19-03-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:84-19-03-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-19-03-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-19-03-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-19-03-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.

N8238PByer Connor · Brenham, TXBuilt 1980 · S/N 32-8024033 N823WWHoffman Richard D · Waterford, WIBuilt 1997 · S/N 20017 N8241ABaloga David M · Payson, AZBuilt 1982 · S/N 32R-8229060 N8243LFieri Doug · La Verne, CABuilt 1980 · S/N 32-8024035 N82470Tfto LLC · Franklin, TNBuilt 1984 · S/N 32R-8429016 N8248QElkhart Flying Club Inc · Nappanee, INBuilt 1982 · S/N 32R-8329004 N824GTBmi Aviation LLC · Bartlesville, OKBuilt 2000 · S/N 2010 N824KLN824kl LLC · Lakewood, CABuilt 1973 · S/N 73-32-123 N824PGMount Olive Flight Club LLC · Mount Olive, NCBuilt 1982 · S/N 31-8252055 N824RCAquila Consulting Services LLC · Los Angeles, CABuilt 2004 · S/N T18208305 N824WBest Start Inc · Kingman, AZBuilt 1982 · S/N 32R8229032 N8250PSedberry Jason A · Kokomo, INS/N 24-2563 N82532Smithy Grain Inc · Presho, SDBuilt 1980 · S/N 32-8024039 N8254RKrejci Ryan J · Sandstone, MNBuilt 1972 · S/N 32-88 N8255RTwo River Airspray LLC · Cavalier, NDBuilt 1972 · S/N 32-72 N8258PThings That Fly LLC · Phoenix, AZBuilt 1963 · S/N 24-3511 N8258RNewo Aviation LLC · Garden City, KSS/N 32-66 N825XSktr Ac LLC · Fallbrook, CABuilt 2006 · S/N 3255043 N8261TDoss Brothers Inc · Lawrenceburg, TNBuilt 1980 · S/N 32-8024043 N8263EN8263e LLC · Jackson, MIS/N 32-8024046 N82646Downs Ricky R Trustee · Roundup, MTS/N 36-7760127 N82654Horomanski Eugene E · Duncansville, PABuilt 1980 · S/N 32-8024048 N82656Souther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1977 · S/N 36-7760134 N8265RMirrorstriker Aviation LLC · Tomball, TXBuilt 1972 · S/N 32-73 N8268VMcs Inc · Loveland, COBuilt 1980 · S/N 32-8024050 N82692Piper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960044 N826CFHanekamp John W · Glen Carbon, ILBuilt 2001 · S/N T182-08091 N826DDRegistered aircraftBuilt 2004 · S/N T18208357 N8275RRensberger Scott C · Lake Jackson, TXBuilt 1972 · S/N 32-84 N8278RSutton Barry W · Longview, TXBuilt 1972 · S/N 32-82 N8279YSaratoga Aviation LLC · Sioux Falls, SDBuilt 1980 · S/N 32-8024052 N82813Preside Management Inc · Coachella, CABuilt 1980 · S/N 32-8124001 N8282KNoyes Tony · Lewisville, TXS/N 32R-8129002 N8282NMercury Aircraft Holdings Inc · West Monroe, LABuilt 1980 · S/N 32R-8129003 N8287RHuhnke John · Newburgh, INBuilt 1972 · S/N 32-81 N828BDEchols Mill Aviation LLC · Elberton, GABuilt 1982 · S/N 31-8212017 N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160 N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098 N828LBBeraut Olivier Trustee · Scotts Valley, CABuilt 1972 · S/N 32-7240077 N828PDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N 1085 N828SRGulfcoast Aviation Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887169 N82908Hall Charles R · Leawood, KSBuilt 1982 · S/N 32-8324001 N8292TJames Peterson Sons Inc · Medford, WIBuilt 1982 · S/N 32R-8329001 N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277 N829CJetran LLC · Horseshoe Bay, TXBuilt 2005 · S/N 3255039 N829MAChambers Reed · Falmouth, MEBuilt 2001 · S/N T18208036 N82FLVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18281007 N82FWRemkes Wolfgang H J Trustee · Gilroy, CABuilt 2001 · S/N T18208027 N82KGBch Real Estate LLC · Eagle, IDBuilt 2005 · S/N T18208440 N82LLSda Aviation LLC · Winnsboro, LABuilt 2000 · S/N 46-36289

Back to AD 84-19-03 R1