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.

N3592YArcher Donald B · Artesia, NMBuilt 1962 · S/N 18254492 N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808 N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081 N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812 N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693 N3593UBdg Holdings Inc · Kingston, PABuilt 1969 · S/N 18259866 N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083 N35945Illinois Department Of Transportation · Springfield, ILBuilt 1975 · S/N U20602819 N35947Continental Construction Inc · Alpine, WYBuilt 1975 · S/N U20602821 N3594CNichols Jamie · Naples, MEBuilt 1955 · S/N 26638 N3594FFirst Flight Corp · San Diego, CABuilt 1966 · S/N 18257594 N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694 N35952Johnson Deborah K · Fairbanks, AKBuilt 1974 · S/N U20602825 N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829 N3595JSchroeder Glenda P · Evansville, INBuilt 1965 · S/N 15061295 N3595SBarnett Carl Chris · Todd, PABuilt 1963 · S/N 17250795 N3595UBrinkman Eric · Phoenix, AZBuilt 1963 · S/N 18254995 N35962Barker Aviation LLC · Spearfish, SDBuilt 1975 · S/N U20602833 N3596JOld Trail Inc · Baker City, ORS/N 15061296 N3596YHeintz Ludwig C · Covington, LABuilt 1962 · S/N 18254496 N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087 N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601 N3597FLivesay John · Pana, ILBuilt 1966 · S/N 18257597 N3597SHawkins Ronald Lee · Vancouver, WABuilt 1963 · S/N 17250797 N3597VMcleod Patrick J · Overgaard, AZBuilt 1975 · S/N 15076557 N3597YCraig & Craig LLC · Merrillville, INS/N 18254497 N3598CN3598c LLC · Ellisville, MOBuilt 1955 · S/N 26642 N3598JMclaughlin George F · Kennesaw, GABuilt 1965 · S/N 15061298 N3598LBryan Aviation LLC · Peoria, AZBuilt 1965 · S/N 15062398 N3598UDunn Mark · Visalia, CABuilt 1963 · S/N 18254998 N3599SRichner Dennis M · Andover, MNBuilt 1963 · S/N 17250799 N3599VMakee Markus · Painesville, OHBuilt 1975 · S/N 15076558 N3599YLooker Daniel M · Ferndale, WABuilt 1962 · S/N 18254499 N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020 N359BDHoffman Brian T · Flower Mound, TXBuilt 1980 · S/N 21064054 N359CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281535 N359DACessna 359da LLC · Warsaw, VABuilt 1979 · S/N U20605240 N359DBKiehne Gary L · Springerville, AZBuilt 1960 · S/N 18253026 N359RCWingsleasing LLC · Wichita, KSBuilt 1977 · S/N R1722427 N359SPSilverhawk Aviation Academy Oregon LLC · Ontario, ORBuilt 2003 · S/N 172S9500 N359TWDouble Bogey Aviation LLC · Midland, TXBuilt 2004 · S/N 18281477 N35BRSlaughter Robert H · Spring, TXBuilt 1975 · S/N 18264274 N35CFGilbert David · Othello, WABuilt 1972 · S/N 18261235 N35GVMartin Scott W · Bowie, MDBuilt 1976 · S/N 18264828 N35MQFly Planet LLC · Kalispell, MTBuilt 1973 · S/N 18262505 N35RJEarles Kenneth D · Crowley, LABuilt 1966 · S/N 15062932 N35VHBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18268129 N35WD4lo Air & Land LLC · Damascus, ORS/N 2050234

Back to AD 79-10-14 R1