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.

N3691YHunt Lynn C Trustee · Windsor, CAS/N 21058191 N3692CDevil Dusters Inc · Artesia, NMS/N 31191 N3692SBrown Wesley B · Sparks, NVBuilt 1963 · S/N 17250892 N3692UPineview Ac Sales LLC · Bedford, WYBuilt 1963 · S/N 18255092 N3693SChianese Anthony · Wylie, TXBuilt 1963 · S/N 17250893 N3694SJstream Lc · Sheridan, WYBuilt 1963 · S/N 17250894 N3694UPara Tactics LLC · Shelton, WAFirst renewal noticeBuilt 1963 · S/N 18255094 N3694YScott Dale D · Alliance, OHBuilt 1963 · S/N 21058194 N3695SZavada Michael S · Morris, MNBuilt 1963 · S/N 17250895 N3695YAffordable Aviation Corp · Moriches, NYBuilt 1963 · S/N 21058195 N3697LShearair LLC · Valparaiso, INS/N 17253866 N3697SRossi Michael · Big Pine, CABuilt 1963 · S/N 17250897 N3698CTomlinson John J · Kent, WABuilt 1954 · S/N 31197 N3698JWise Tammy B · Eden, NCBuilt 1966 · S/N 15064998 N3698UJk Fly LLC · Abie, NEBuilt 1963 · S/N 18255098 N3699JBlock Time Bandits LLC · Boise, IDBuilt 1966 · S/N 15064999 N3699YAmfreight Logistics LLC · Deltona, FLBuilt 1963 · S/N 21058199 N369ADManston Quinton A · White, GABuilt 1977 · S/N 17269479 N369ANJet Aircraft Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280696 N369CBHahn Mitchell S · Chagrin Falls, OHS/N 182-66699 N369CMOharra Robert J · Buckley, WABuilt 1969 · S/N 18052058 N369CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12346 N369DADuan Ran · Bothell, WABuilt 2023 · S/N 172S13041 N369ERTower Aviation Management LLC · Decatur, TXFirst renewal noticeS/N 172RG0062 N369GTTokar Gary J · Howell, MIBuilt 1960 · S/N 52608 N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049 N369KSkydive Inc · Eagle Creek, ORBuilt 1963 · S/N 18254634 N369MBBarnes Matthew L · Pacific Palisades, CABuilt 1979 · S/N 18266986 N369METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 20608125 N369NEPeter Travis E · Evansville, WYBuilt 1979 · S/N 172RG0233 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N369RJD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17273068 N369SPXin Han Aviation LLC · Helena, MTS/N 17262809 N369TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9063 N369WPLego Aviation LLC · Grimes, IABuilt 2025 · S/N 18283327 N36APAnalysis Inc · Grand Junction, COBuilt 1971 · S/N 18052206 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N36GBSmokey Bay Air Inc · Homer, AKBuilt 1972 · S/N U20601854 N36GRRiethof George N · Nantucket, MABuilt 1978 · S/N 17272026 N36JCSafety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 17261759 N36JRCatching Freedom LLC · Bozeman, MTS/N 172S11204 N36JWBarr Air Patrol LLC · Mesquite, TXBuilt 1975 · S/N 17265589 N36MJFinland Leasing Co Inc · Quakertown, PABuilt 1980 · S/N 18504104 N36MSFlying Medical Service Inc · Grosse Pointe, MIBuilt 1976 · S/N U20603244 N36NHAlgar Linda · Tucson, AZBuilt 1980 · S/N 18267589 N36RCAiken Air Sales And Rentals LLC · Aiken, SCBuilt 1970 · S/N 18260311 N36SBWollenberg Jeffrey · Concrete, WABuilt 1956 · S/N 32271 N36SKFortin Jean T · Mechanicville, NYBuilt 1963 · S/N 17250459 N36STGriffith Joshua S · Breckenridge, TXBuilt 1979 · S/N 18267282

Back to AD 79-10-14 R1