Registered aircraft · 20,483

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-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

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.

N3376RStumm Robert W · Cadott, WIBuilt 1967 · S/N 18258676 N3376YFly Greater Breezewood LLC · Clearville, PABuilt 1962 · S/N 18254376 N3377RLonestar Aeronautics LLC · Paige, TXBuilt 1967 · S/N 18258677 N3378CWaples Charles Andrew · Red Lodge, MTBuilt 1978 · S/N R18200277 N3378UJeppson Edward M · Nephi, UTBuilt 1963 · S/N 18254778 N3379UJames Mccullough · Hempstead, TXBuilt 1963 · S/N 18254779 N337BMSky Drivers LLC · La Fayette, GABuilt 1999 · S/N 18280629 N337CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283116 N337DBOlson Vienette · White Bear Lake, MNBuilt 2001 · S/N 18281027 N337DMMcwhorter Michael S · Fortuna, CABuilt 1968 · S/N P206-0471 N337PCPhantom Technologies LLC · Garden City, IDBuilt 1980 · S/N 21064212 N3380DRussell Robert J · Wasilla, AKBuilt 1956 · S/N 32178 N3380RHunter Robert R · Springville, PABuilt 1967 · S/N 18258680 N3380YLaramie Flying Club Inc · Laramie, WYBuilt 1962 · S/N 18254380 N3381FAttema Symon Nmi · Norco, CABuilt 1966 · S/N 18257381 N3381UCenter Of Excellence Corp · Cheyenne, WYBuilt 1963 · S/N 18254781 N3382DBond Jeffrey A · Las Cruces, NMBuilt 1955 · S/N 32180 N3382RWatch Out LLC · Scottsdale, AZBuilt 1967 · S/N 18258682 N3382YJenkinson John III · Lakin, KSBuilt 1962 · S/N 18254382 N3383DStyer Michael J · Amarillo, TXBuilt 1955 · S/N 32181 N3383RDeatley Derek · Mohave Valley, AZBuilt 1967 · S/N 18258683 N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183 N3383YJohnson Brian B · Monroe, LABuilt 1962 · S/N 18254383 N3384R3384 Romeo LLC · Jackson, MOBuilt 1967 · S/N 18258684 N3384YOliveira John S · Plant City, FLBuilt 1962 · S/N 18254384 N3385RHill David A Jr · Needham, MABuilt 1967 · S/N 18258685 N3385YNoah Aviation LLC · Ellabelle, GABuilt 1962 · S/N 18254385 N3386FN3386f Flying Club Inc · Pickerington, OHBuilt 1966 · S/N 18257386 N3387FChristensen Robert F · Gillette, WYBuilt 1966 · S/N 18257387 N3387RSkypartners LLC · Buhler, KSBuilt 1967 · S/N 18258687 N3387USkynick Enterprises Inc · Tarzana, CAS/N 18254787 N3387YBhogal Balvinder S · Biloxi, MSBuilt 1962 · S/N 18254387 N3388RFamily Air Fares LLC · Wilmington, DEBuilt 1967 · S/N 18258688 N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188 N3388UMenard Charles H · Grand Blanc, MIBuilt 1963 · S/N 18254788 N3388YMeeks Peris M · Gardena, CAS/N 18254388 N3389DRegistered aircraftBuilt 1955 · S/N 32187 N3389UThompson Anthony D Trustee · Rockwall, TXS/N 18254789 N338BMMorton William · Darby, MTBuilt 1979 · S/N 18267111 N338LMSisk Stephen A · Greenville, ILBuilt 1968 · S/N 18259244 N338MEBoulant Michael Lee Charles · Las Vegas, NVBuilt 2000 · S/N 18280730 N3390FRodgers Christian Joseph · Ormond Beach, FLS/N 18257390 N3390YHead John T Jr · Port St Joe, FLS/N 18254390 N3391FKingston Terry D · Irving, TXBuilt 1966 · S/N 18257391 N3392DHaszard John R · Ophelia, VABuilt 1955 · S/N 32190 N3394DCartledge Charles J · Orrville, OHBuilt 1955 · S/N 32192 N3394RCurren Patrick V · Green Bay, WIBuilt 1967 · S/N 18258694 N3394YNolt Ivan M · Mount Solon, VABuilt 1962 · S/N 18254394 N3395DFitzgerald John A Jr · Ester, AKBuilt 1955 · S/N 32193 N3395RJohnston Osceola Holdings LLC · Dallas Center, IABuilt 1968 · S/N 18258695

Back to AD 84-10-01 R1