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.

N207BHElevation Squad Inc · York, PABuilt 1982 · S/N 20700735 N207CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13071 N207CCAbaco Fire Rescue Association Inc · Lewes, DEBuilt 1979 · S/N 20700488 N207CHAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1969 · S/N 20700039 N207CZBig Sky Aviation Inc · Wilmington, DEBuilt 1976 · S/N 20700355 N207DAKolb Austin · Phoenixville, PAS/N 20700607 N207DDHillyard Robert Keith · Dallas, TXBuilt 1969 · S/N 20700049 N207DFDouble R Air LLC · Miami, FLBuilt 1978 · S/N 20700430 N207DGRwr Air Inc · Tok, AKBuilt 1969 · S/N 207-00070 N207DLRegistered aircraftBuilt 1981 · S/N 20700712 N207DRRadicke Dixie A · Uvalde, TXS/N 20700372 N207ECCianchette Eric · Falmouth, MEBuilt 1952 · S/N 25328 N207FDElevation Squad Inc · York, PABuilt 1982 · S/N 20700760 N207GAngry Dragon LLC · St Thomas, VIBuilt 1969 · S/N 20700091 N207GHBridgeview Aviation LLC · Southfield, MIS/N 20700709 N207GMWaters Aero Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700217 N207GRBlue Sky Telluride LLC · Telluride, COBuilt 1979 · S/N 20700563 N207HAP & C Leasing LLC · Jupiter, FLS/N 20700742 N207HPCampbell James W · Geneva, ALBuilt 1982 · S/N 17275543 N207JUnwrapped LLC · Dover, DEBuilt 1965 · S/N P206-0086 N207JPWaters Aero-Marine Inc · Owls Head, MEBuilt 1974 · S/N 20700255 N207MRVanderpool Robert W Sr · Red Devil, AKBuilt 1996 · S/N 20700424 N207NEHylton Kyler E · Palmer, AKBuilt 1954 · S/N 31030 N207NNCasaccio Paul E · Beesleys Point, NJBuilt 1969 · S/N 20700040 N207PAMcnutt Ross T · Xenia, OHBuilt 1970 · S/N 20700162 N207PBBernstein Petra M · Salisbury, MDBuilt 2006 · S/N 18281771 N207RBSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 20700606 N207SADyer LLC · Dyer, TNBuilt 1998 · S/N 18280140 N207SFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13485 N207SRJaars Inc · Waxhaw, NCS/N 20700623 N207TFPhotos Unlimited Inc · Rancho Cordova, CABuilt 1978 · S/N 20700492 N207VWVanderwel Mark E · Monroe, WABuilt 1975 · S/N 20700311 N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647 N207YHGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700637 N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216 N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217 N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841 N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219 N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220 N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147 N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280 N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N20818N20818 LLC · Wilmington, DES/N 172S12579 N2081JWings Over Texas Holdings LLC · Denton, TXS/N 17280995 N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023 N2081ZMcfarland Ryan E · Jacksonville, FLBuilt 1963 · S/N 15059881 N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeBuilt 1972 · S/N 18261236 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849

Back to AD 79-10-14 R1