Skip to content

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

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.

N732LTPerfection Training Kennels LLC · Gallatin, MOS/N 21061603 N732MYGrand River Construction Co · Glenwood Springs, COS/N 21061631 N732NCM And N Aviation Inc · Perkasie, PABuilt 1976 · S/N 21061635 N732NLHutton Construction Inc · Florence, MTBuilt 1976 · S/N 21061643 N732NSCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N U20604704 N732PGSims Chas W · Deer Park, TXS/N 21061661 N732PQPilcher Nick A · Perryton, TXBuilt 1976 · S/N 21061669 N732PXGerst Charles A · Dandridge, TNBuilt 1976 · S/N 21061676 N732QAInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 21061679 N732QCHoldaway Daniel C · Orem, UTBuilt 1976 · S/N 21061681 N732QLSullivan John E · Ann Arbor, MIBuilt 1976 · S/N 21061689 N732QXT & A Transport LLC · Garden City, KSBuilt 1977 · S/N 21061700 N732RBGauthier Alan Trustee · Flemington, NJBuilt 1977 · S/N 21061704 N732RLAero Aviation Transportation Inc · Wilmington, DEBuilt 1977 · S/N 21061713 N732RMMaples Jeffery · Wilmington, DEBuilt 1977 · S/N 21061714 N732RTRome Aviation Group LLC · Rome, GABuilt 1977 · S/N 21061720 N732RURegistered aircraftBuilt 1978 · S/N U20604713 N732RVJongum LLC · Allentown, PAS/N 21061722 N732SEPic Aviation Inc · Bloomsburg, PABuilt 1977 · S/N 21061731 N732SFEnterprise Electric And Rental Inc · Enterprise, ORBuilt 1977 · S/N 21061732 N732SMKonstantinopoulos George · Vacaville, CABuilt 1977 · S/N 21061738 N732SRLucas Gilbert C DBA · Santa Rosa, CABuilt 1977 · S/N 21061742 N732SSAlbert Aviation LLC · Kalispell, MTBuilt 1977 · S/N 21061743 N732STFox Kevin · Polson, MTBuilt 1977 · S/N 21061744 N732SVN732sv LLC · Dallas, TXS/N 21061746 N732TCKam Aviation LLC · Maryville, TNBuilt 1977 · S/N 21061753 N732TJEscalante Aviation LLC · Boerne, TXBuilt 1976 · S/N 21061507 N732TPBdf Air Investments LLC · Galveston, TXBuilt 1977 · S/N 21061764 N732TYTennison Gary · Marion, TXBuilt 1977 · S/N 21061772 N732UHUpwind Air LLC · Atoka, OKBuilt 1977 · S/N 21061781 N732UJJohnson Andrew · Carrollton, TXBuilt 1977 · S/N 21061782 N732UMCurtis Blake B · Clovis, NMBuilt 1977 · S/N 21061785 N732UUAll In Flying Co · Wilmington, DEBuilt 1977 · S/N 21061792 N732UWCenturion Cats LLC · Manhattan, KSBuilt 1977 · S/N 21061794 N732VFVictor Fox Aviation LLC · Newport Beach, CABuilt 1998 · S/N 18280296 N732VGCrystal Air LLC · Onida, SDBuilt 1977 · S/N 21061804 N732VPStoneman Excav Co Inc · Manakin Sabot, VABuilt 1977 · S/N 21061811 N732VRChurchill David A · Moab, UTBuilt 1977 · S/N 21061813 N732VURegistration Pending · Port Clinton, OHRegistration pendingS/N 21061816 N732WFWestairnetwork LLC · Kalispell, MTBuilt 1977 · S/N 21061827 N732WNKilpatrick Robert Levon · Auburndale, FLBuilt 1977 · S/N 21061834 N732WPSky Wings Aviation LLC · Cedar Rapids, IABuilt 1977 · S/N 21061835 N732WQLos Angeles County Sheriffs Department · Long Beach, CABuilt 1977 · S/N 21061836 N732WSMurphy Timothy J Trustee · Arcadia, CABuilt 1977 · S/N 21061838 N732XFWwabfa LLC · Dallas, TXBuilt 1977 · S/N 21061851 N732XL5239g LLC · Auburn, ALBuilt 1977 · S/N 21061856 N732XTB&S Air Holdings LLC · Fort Myers, FLBuilt 1977 · S/N 21061863 N732XVHanley John F · Chicago, ILBuilt 1977 · S/N 21061865 N732XXKnieper Kenneth · Granbury, TXBuilt 1977 · S/N 21061867 N732YBRieber Gerald Michael · Watertown, SDS/N 21061871

Back to AD 84-10-01 R1