Registered aircraft · 56,578

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.

N1409QDjz Aviation LLC · Kalispell, MTBuilt 1971 · S/N 15072709 N140ABWiliams Steve C · Elgin, SCS/N 15703 N140CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13254 N140CFBowser Brett A · Murfreesboro, TNBuilt 1949 · S/N 15369 N140CTKollar Aviation LLC · Apollo Beach, FLBuilt 2015 · S/N 18282382 N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539 N140LAAllen Lynn A II · Waxahachie, TXBuilt 1949 · S/N 15338 N140LMLambson Roger S · Saint Ignatius, MTBuilt 1950 · S/N 15588 N140MAMindy Limited LLC · Muscatine, IABuilt 1970 · S/N 15072399 N140MQWasem John S · Nome, AKFirst renewal noticeS/N 15505 N140NTFlight International Inc Trustee · Dover, DES/N 15396 N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241 N140PDCoulouris George L · Washington, DCBuilt 1950 · S/N 15414 N140RADenome Vincent G · Tampa, FLBuilt 1999 · S/N 172S8312 N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478 N140SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11563 N140UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11489 N140WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276201 N1410DMahaffey James P · Grand Prairie, TXBuilt 1951 · S/N 19993 N1410EGulf Atlantic Airways Inc · Gainesville, FLBuilt 2008 · S/N 172S10667 N1410GSierra-Mike LLC · Springdale, ARS/N 15073205 N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110 N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906 N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080 N1411VForbes David · Garden Grove, CABuilt 1976 · S/N R1722186 N1412DKing Matthew W · Wilmington, NCBuilt 1951 · S/N 19995 N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712 N1412SJ&J Aviation LLC · Thedford, NEBuilt 1976 · S/N 18264971 N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908 N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713 N1413SAgillaire Inc · Colleyville, TXS/N 18264972 N1413VMercury International LLC · Cheyenne, WYS/N R1722187 N1413YSooter Craig A · Sedgwick, KSBuilt 1961 · S/N 17249113 N1414CSorby Steven R · Lyman, WABuilt 1966 · S/N 337-0419 N1414FPalmer Matthew B · Riverside, CABuilt 1966 · S/N 17254909 N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714 N1414VMoeller Rita L · Rescue, CABuilt 1974 · S/N 17263559 N1415DMurphy James S · Skaneateles, NYBuilt 1951 · S/N 20131 N1415MJ T Air LLC · Cleveland, ALBuilt 1975 · S/N 18264321 N1415USale Reported · Miami, FLSale reportedBuilt 1976 · S/N 17267083 N1416ESalem Pilots Association · Salem, ORBuilt 1978 · S/N 17270989 N1416MTerra Firma Aviation LLC · Bowman, CABuilt 1975 · S/N 18264322 N1416UEddy Elizabeth H · Tunbridge, VTBuilt 1976 · S/N 17267084 N1416VRegistered aircraftBuilt 1976 · S/N R1722188 N1416WGulf Atlantic Airways Inc · Gainesville, FLS/N 172S10669 N1416YOrefice Anthony C · Clio, MIBuilt 1961 · S/N 17249116 N1417MRegistered aircraftBuilt 1975 · S/N 18264323 N1417QSteinke William A · Mount Juliet, TNBuilt 1971 · S/N 15072717

Back to AD 79-10-14 R1