Registered aircraft · 1,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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014 N12TTThoms Robert D · Clyde, MIS/N 310H0066 N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171 N12WTMtzb Corp · New York, NYBuilt 1974 · S/N 421B0829 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1313RAztexas LLC · Valley Farms, AZS/N 310J0178 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N1322GSmetters Jeffrey L · Crystal Lake, ILBuilt 1974 · S/N 310Q1160 N1338UJstream Lc · Sheridan, WYBuilt 1965 · S/N 411-0105 N1361QLannigan Anthony Robert · Tucson, AZBuilt 1959 · S/N 39017 N137Bigfoot Aviation LLC · Saint Michael, MNBuilt 1960 · S/N 310-0028 N138JGCloud Cruisers LLC · Falls Of Rough, KYBuilt 1975 · S/N 421B0952 N13BPN13bp LLC · Walla Walla, WAS/N 320D0123 N13HLFreedom 421b LLC · Jacksonville, FLBuilt 1975 · S/N 421B0927 N13MFAeromedicos Gb Inc · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0253 N141DEEssex Lisa · Oceanside, CABuilt 1973 · S/N 310Q-0805 N1421UAviation Services Of Tn Inc · Sparta, TNBuilt 1967 · S/N 421-0046 N143MGPatriot Air Inc · Maryland Heights, MOS/N 310K0134 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333 N1491Petecraft Aviation Services Inc · Plains, GABuilt 1960 · S/N 39202 N14BRGobin Albert W · Crawfordsville, INS/N 310K0104 N14MCBlue Skies Blue Water LLC · Henderson, NVBuilt 1964 · S/N 320C0008 N14RTSierra Ae LLC · Wilmington, DEBuilt 1974 · S/N 421B0640 N1510GGmr Leasing LLC · Lincoln, DEBuilt 1974 · S/N 421B0606 N1527GHanley Thomas W · Kissimmee, FLBuilt 1974 · S/N 421B0623 N1534GRugger Investment Group LLC · Tustin, CAS/N 421B0630 N153RJones Jeremy R · Lampasas, TXS/N 35020 N1543GQds Aviation LLC · Baton Rouge, LABuilt 1974 · S/N 421B0639 N1549TPalmer Jonathan L · The Woodlands, TXBuilt 1973 · S/N 310Q0755 N1557GAirperks LLC · Kalispell, MTBuilt 1974 · S/N 421B0653 N155JQualitair LLC Trustee · MichelstadtBuilt 1972 · S/N 421B-0246 N157CCWhite David W · South Fulton, TNS/N 310I0157 N1592GCtl Legacy Holdings LLC · Midland, TXBuilt 1974 · S/N 421B0822 N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079 N15JDSwanson Alec · Hanahan, SCBuilt 1972 · S/N 310Q0476 N15ZPStefenelli Aviation N Tr Inc Trustee · AtterseeS/N 421B0919 N165MHFortune Kyle D · Hampstead, NCBuilt 1966 · S/N 310K0173 N166AMColvin Clu D DBA · Big Cabin, OKBuilt 1963 · S/N 310H0127 N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044 N16ASStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 421B0317 N16SGWard James · Arroyo Grande, CABuilt 1957 · S/N 35591 N1710HQuon Nicholas · Fayetteville, GABuilt 1959 · S/N 35810 N1712HColvin Clu D DBA · Big Cabin, OKS/N 35812 N1718HSale Reported · Bartlesville, OKSale reported, pending cancellationBuilt 1959 · S/N 35818 N1722HWashington State Community College · Spokane, WABuilt 1959 · S/N 35822 N1731HDonadio Robert F · Amherst, NHS/N 35831 N174KBlueskies Aviation Services LLC · Charlestown, INBuilt 1968 · S/N 310N-0143

Back to AD 72-14-08 R1