Skip to content

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.

N27527N27527 LLC · Florence, SCBuilt 1977 · S/N 31-7852044 N27528Seacrest Seven LLC · Savannah, GABuilt 1977 · S/N 31-7852045 N27562Montcalm-Mcdonald LLC · Mansfield, LABuilt 1978 · S/N 31-7812050 N27567Plecenik William J · Erwinna, PABuilt 1978 · S/N 31-7812054 N275CTInfinity Real Estate LLC · Guaynabo, PRBuilt 1979 · S/N 318052019 N27647Aviation Department Inc · Avon Park, FLBuilt 1978 · S/N 31-7812084 N2765VWiebe Frank · Wellington, TXBuilt 1978 · S/N 31-7812048 N27663Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7852094 N27666Lee Stephan J · Sacramento, CABuilt 1978 · S/N 31-7852097 N27674Georges Aviation Services Inc · Honolulu, HIBuilt 1978 · S/N 31-7852100 N27682D And R Hobbs Properties LLC · Rogers, ARBuilt 1978 · S/N 31-7852105 N27693Sanborn Map Co Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812091 N27699Curnutt Daniel E · Tanner, ALBuilt 1978 · S/N 31-7812094 N276CD&D Airpark LLC · Anchorage, AKBuilt 2002 · S/N 3257299 N276FLFrogman Properties LLC · Tampa, FLBuilt 2002 · S/N 3257276 N27701Secure Aviation Inc · Tequesta, FLBuilt 1978 · S/N 31-7812096 N2772PFix Repair LLC · Helena, MTBuilt 1968 · S/N 32-40456 N27755Air Arctic Inc · Fairbanks, AKBuilt 1978 · S/N 31-7852148 N2777NSpencer John · Indian, AKS/N 32-7240003 N277USCooper Robert · Sugar Grove, ILBuilt 2000 · S/N 18280894 N27835Aerowerks LLC · Louisville, KYBuilt 1978 · S/N 31-7912016 N27850Presby Aire LLC · Berlin, NHBuilt 1978 · S/N 31-7912024 N27888Tep LLC · Ormond Beach, FLBuilt 1978 · S/N 31-7952025 N278RCSanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7912018 N27917Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7952007 N27987Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 31-7912054 N27989Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952077 N27990Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1979 · S/N 31-7952079 N279JHBravo Zulu Aviators LLC · Midland, TXBuilt 1978 · S/N 32-7840138 N27BRLarson Allen L · Capron, ILBuilt 1969 · S/N 24-4909 N27DVDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N T20608111 N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087 N27RZHq Wings LLC · Porterville, CAS/N 4636299 N27ZZJohnson John C · Coeur D Alene, IDBuilt 1964 · S/N 310I0100 N2802WMejias Michael · Miami Gardens, FLS/N 1137 N2804WSacco Christopher M · Mechanicsville, MDS/N 1039 N2805RMurphy Tyson L · Greensboro, NCS/N 1138 N280JBS & S Properties Inc · N Kansas City, MOBuilt 1998 · S/N 3257043 N280KCMccarty Anthony O · Saint Augustine, FLBuilt 1999 · S/N 4636219 N280KTGetchell Investments LLC · Dallas, TXBuilt 2002 · S/N 4636329 N280MBWeber Donald E · St David, AZBuilt 1975 · S/N 3255 N28119Page Gregory G · Roosevelt, UTBuilt 1978 · S/N 78-31146 N28160Sobol Anthony J · Sandia Park, NMBuilt 1979 · S/N 79-31153 N28200Holland Joshua · Glendale, AZBuilt 1978 · S/N 78-31149 N2821GH&M Air LLC · Metamora, MIBuilt 1979 · S/N 32-7940137 N2826HN2826h LLC · Elizabethville, PABuilt 1979 · S/N 32-7940144 N2826XAero Talons LLC · Nashville, TNS/N 32-7940145 N283GTKinz Air LLC · Winter Springs, FLBuilt 1979 · S/N 31-7952139 N283SSSmith Scott R · Grand Junction, COBuilt 1997 · S/N 4636080 N2843GPopop Corp · Portland, ORBuilt 1979 · S/N 32-7940152

Back to AD 84-19-03 R1