Skip to content

Registered aircraft · 20,486

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.

N1387MJ&D Aero LLC · Wilmington, DEBuilt 1975 · S/N 18264308 N1387SGalaz Nick Anthony · Lake Havasu City, AZBuilt 1976 · S/N 18264948 N1388SCowboy Taxi LLC · Payson, AZBuilt 1976 · S/N 18264949 N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569 N1391SWysong Charles J · Hickory, NCBuilt 1976 · S/N 18264952 N1392SAbc Flying Club Inc · West Mifflin, PABuilt 1976 · S/N 18264953 N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955 N1395SGarcia Robert W · Floresville, TXS/N 18264956 N1397MRichs Inc · Wilmington, DES/N 21061940 N1397SKnotty Aviation LLC · Fort Myers, FLBuilt 1976 · S/N 18264958 N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959 N1399MRegistered aircraftBuilt 1975 · S/N 18264314 N1399SDesmond Brett Kyle · Mars, PABuilt 1976 · S/N 18264960 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614 N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195 N13BJSevcik Clint · Medford, MNS/N 21058486 N13DSR & M Adventures LLC · Wichita, KSBuilt 1980 · S/N 18267798 N13FGBaum Group LLC · Shavertown, PABuilt 1957 · S/N 34271 N13HWSikes Alan · Collins, GABuilt 1962 · S/N 1850290 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202 N13MCMathison Neil James · Solon Springs, WIBuilt 1974 · S/N 18052444 N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N13WTBentz George T · Missoula, MTBuilt 1973 · S/N 18262089 N14007Kga Aviation LLC · Alfred, MEBuilt 2005 · S/N 18281589 N1401Prestonlines LLC · Wilmington, DEBuilt 1950 · S/N 7540 N1402SJohnston Matthew A · Ventura, CABuilt 1976 · S/N 18264962 N1403SFarnsworth Scott · Crestwood, KYBuilt 1976 · S/N 18264963 N1404SRegistration Pending · Englewood, CORegistration pendingS/N 18264964 N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318 N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965 N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851 N1407SCaesar Wings LLC · Ubly, MIBuilt 1976 · S/N 18264967 N1408SFrickel Well Service LLC · Atkinson, NEBuilt 1976 · S/N 18264968 N140CTKollar Aviation LLC · Apollo Beach, FLBuilt 2015 · S/N 18282382 N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1412SJ&J Aviation LLC · Thedford, NEBuilt 1976 · S/N 18264971 N1413SAgillaire Inc · Colleyville, TXS/N 18264972 N1415MJ T Air LLC · Cleveland, ALBuilt 1975 · S/N 18264321 N1416MTerra Firma Aviation LLC · Bowman, CABuilt 1975 · S/N 18264322 N1417MRegistered aircraftBuilt 1975 · S/N 18264323 N1417SCooper Patrick R · Houston, TXBuilt 1976 · S/N 18264974 N1419SKingdom Air Corps · Sutton, AKBuilt 1976 · S/N 18264975 N141DMTurbo Inc · Flint, MIBuilt 1977 · S/N 21061806 N141HSss Inc · Anchorage, AKS/N 185-0404 N141WBElevated Dreams Aviation LLC · Huntington, NYBuilt 1976 · S/N 18265249 N14205Dfi Aviation Services LLC · Herndon, VABuilt 2007 · S/N 18281889 N1420EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268177

Back to AD 84-10-01 R1