Registered aircraft · 56,572

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N102AKRegistered aircraftBuilt 2006 · S/N 20608264 N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024 N102BNDelta State University · Cleveland, MSBuilt 1978 · S/N U20604268 N102BROtv Leasing · Bristow, VABuilt 2010 · S/N 18282264 N102CDrain Alan K · Columbus, MTS/N 30501 N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552 N102HWDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281058 N102JJGrose Christopher E · San Antonio, TXBuilt 1966 · S/N T210-0123 N102KSKent State University · Stow, OHBuilt 2005 · S/N 172S10091 N102LAIowa Lakes Community College · Estherville, IAS/N 17259038 N102LPWashington State Patrol · Olympia, WABuilt 2002 · S/N 18281121 N102MASquaw Creek Aviation LLC · Dover, DES/N 18280100 N102MUTraining Planes LLC · Tampa, FLBuilt 1997 · S/N 17280285 N102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462 N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570 N102WBArtemis Inc · Hauppauge, NYBuilt 1968 · S/N 337M0104 N10300Registration Pending · Centreville, VARegistration pendingBuilt 1973 · S/N 15074832 N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319 N10310Solow Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 15074836 N10312Allmann Mark F Trustee · Kent, WABuilt 1973 · S/N 15074837 N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409 N1032MHoyer Bryan H · Friday Harbor, WABuilt 1970 · S/N 15071732 N1032VMatlock Jimmy R · Granbury, TXBuilt 1976 · S/N R1722088 N1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238 N1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 172S10598 N1036MMangon Aircraft Inc · Petaluma, CABuilt 2007 · S/N 172S10599 N1037MHager Winfield D · Peytona, WVBuilt 1970 · S/N 15071737 N1037TJohnson Shem E · Bonners Ferry, IDBuilt 1972 · S/N 18260859 N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989 N10380Jones Jeffrey J · Wallingford, PABuilt 1973 · S/N 15074842 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N1039PN1039p LLC · Suwanee, GABuilt 2005 · S/N 18281566 N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615 N103ARHd Outdoor Advs LLC · Coalgate, OKBuilt 2005 · S/N 18281663 N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365 N103DCCarver Clarence K · Lutz, FLBuilt 1973 · S/N 15075419 N103DLDunwoody Duane E D · Savage, MNS/N 55913 N103ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13534 N103FRSargent William A · Watford City, NDBuilt 1974 · S/N 15075569 N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553 N103KFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1999 · S/N 172S8143 N103KSKent State University · Stow, OHBuilt 2005 · S/N 172S10093 N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298 N103NCState Of North Carolina · Raleigh, NCBuilt 1999 · S/N 18280647 N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372 N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995 N103SGJared William C · Valparaiso, INBuilt 1958 · S/N 17004 N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101 N103SVSun Valley Aviation Inc · Harlingen, TXBuilt 1998 · S/N 17280534 N103TXWilliams Bradley H Jr · Charleston, SCBuilt 2001 · S/N 18280984

Back to AD 79-10-14 R1