Registered aircraft · 56,580

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.

N2813FDan Air LLC · Greenville, SCBuilt 1966 · S/N 18256913 N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013 N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813 N2814CStone Robert D · Anchorage, AKBuilt 1954 · S/N 26357 N2814KMacario Mark A · Weirsdale, FLBuilt 1979 · S/N 18053085 N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014 N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998 N2814RCypress Aviation Inc · Naples, FLBuilt 1967 · S/N 18258414 N2814VCentral Ohio Soaring Association · Marion, OHBuilt 1974 · S/N 15076290 N2814YYankee Tango Mike LLC · Dublin, TXS/N 18253814 N2815CCooper David A · Mc Kittrick, CAS/N 26358 N2815KStudniski Alois W · Saint Joseph, MNS/N 18053086 N2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1967 · S/N 18258415 N2815UHarris Tony James · Stanley, NCBuilt 1963 · S/N 17250415 N2815YFlakes LLC · Fort Worth, TXBuilt 1962 · S/N 18253815 N2816KVigna Douglas Del · Portland, MEBuilt 1979 · S/N 18053087 N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216 N2817ARamey Shane · Buffalo, WYBuilt 1953 · S/N 30017 N2817UAero Ventures Inc · Yukon, OKBuilt 1963 · S/N 17250417 N2818CSchmidt Wolf E · Anchorage, AKBuilt 1954 · S/N 26361 N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704 N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334 N2818FMccullough Andrew · Lubbock, TXS/N 18256918 N2818UWard Jasper Eugene · Telford, TNFirst renewal noticeS/N 17250418 N2818YEaton Melvin W II · Saint Onge, SDS/N 18253818 N2819CLanis Scott E · North Pole, AKBuilt 1954 · S/N 26362 N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819 N2819SBeale Frank B II · Bowling Green, VABuilt 1967 · S/N 15066719 N2819UGartner Thomas M · Newton, KSBuilt 1963 · S/N 17250419 N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219 N281AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281189 N281DKN281dk LLC · Brandywine, MDBuilt 2005 · S/N 18281719 N281EAElevation Air Capital LLC · Janesville, WIBuilt 2023 · S/N 172S13043 N281PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10878 N281RWR Wings LLC · Deland, FLBuilt 2026 · S/N 18283340 N281SLCurly Aviation LLC · Atlanta, GABuilt 1972 · S/N 182-61394 N2820LHarrington Thomas W Jr · Cumming, GAS/N 17256020 N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820 N2820RHutter Karl G · Reno, NVBuilt 1967 · S/N 18258420 N2820XJones Michael S · Fremont, WIS/N 17700220 N2821ALewton John E · Belgrade, MTBuilt 1953 · S/N 30021 N2821K4608 Vista LLC · Fort Lauderdale, FLS/N 18053089 N2821QHattan Richard A Trustee · Fairbanks, AKBuilt 1977 · S/N 18503533 N2821RNielson David L Trustee · Anchorage, AKBuilt 1967 · S/N 18258421 N2821SHancock Jeffrey A · Jacksonville, TXS/N 15066721 N2821UPelotte Raymond J · Waterville, MEBuilt 1963 · S/N 17250421 N2822CNeverman Walter M · Albany, WIBuilt 1954 · S/N 26365 N2822LRobertson IV Henry B · Owensboro, KYS/N 17256022 N2822MWendt Robert R · Sedona, AZBuilt 1953 · S/N 30010 N2822XPender Michael J · Marsing, IDBuilt 1967 · S/N 17700222

Back to AD 79-10-14 R1