Skip to content

Registered aircraft · 6,915

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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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.

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 N276JKGfk Investments LLC · Saint Joseph, MIS/N 4636520 N27701Secure Aviation Inc · Tequesta, FLBuilt 1978 · S/N 31-7812096 N27712Juliet Lima Marketing Inc · West Palm Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 31-7812102 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 N278JHRaytheon Co · Tucson, AZBuilt 2007 · S/N T20608715 N278RCSanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7912018 N278TMBuena Vista Aviation LLC · Fresno, CABuilt 2023 · S/N T20609728 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 N279TWPresotto David L Trustee · Palo Alto, CABuilt 2010 · S/N T18209015 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 N27VANorton Mark H Trustee · Stateline, NVBuilt 2015 · S/N T20609170 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 N2808LNtss LLC · Henderson, NVBuilt 2015 · S/N 4636676 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 N281WSWight David · Alvin, TXBuilt 2006 · S/N T20608611 N28200Holland Joshua · Glendale, AZBuilt 1978 · S/N 78-31149 N28206Huey David G · Sumas, WABuilt 2008 · S/N T20608830 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 N2829JSunrise Aviation LLC · Las Vegas, NVBuilt 2008 · S/N T20608801 N282AUNeice Russell G · Shreveport, LABuilt 2006 · S/N T18208540 N282JSLego Paul Gregory · Watsonville, CABuilt 2007 · S/N T18208682

Back to AD 71-13-01 R1