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.

N36TDThayer Kenneth R · Bonita Springs, FLBuilt 1971 · S/N 15073090 N36WYFlexible Flyer LLC · Cody, WYBuilt 1977 · S/N 18503311 N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650 N36XBSchmidt Thomas P · Nunica, MIBuilt 1956 · S/N 33049 N36XCHangar C-403 LLC · Walnut Creek, CABuilt 1979 · S/N 18267223 N36ZNDawkins Christopher R · Trinity, NCBuilt 1970 · S/N 18501830 N36ZQNorthern Flights LLC · Calumet, MIBuilt 1975 · S/N 17265019 N3700JOluoch Bill Rachuonyo · San Francisco, CABuilt 1966 · S/N 15065000 N3700SMusket Air LLC · Page, AZBuilt 1963 · S/N 17250900 N3700URydberg Lawrence · Albuquerque, NMBuilt 1963 · S/N 18255100 N3701LRice Solutions LLC · Plymouth, NHS/N 17253870 N3701UBowley Steven Jon · Phoenix, AZS/N 18255101 N3702JMaslovsky Serhiy A · Carbondale, ILBuilt 1966 · S/N 15065002 N3702LBailey April O · Papillion, NEFirst renewal noticeS/N 17253871 N3702SWhite Edward H · Waco, KYS/N 17250902 N3702UCc Flyers LLC · Corpus Christi, TXS/N 18255102 N3703JSilver And Associates LLC · Ojai, CAS/N 15065003 N3703SDavis William F · Oak City, NCBuilt 1963 · S/N 17250903 N3703YWilemon Ronald J · Tulsa, OKBuilt 1963 · S/N 21058203 N3704FBrzezinski Samuel M · Boyceville, WIS/N 17255199 N3704LN3704l LLC · Jacksonville, FLBuilt 1965 · S/N 17253873 N3705LRed Five Aviation LLC · Wilmington, DEBuilt 1965 · S/N 17253874 N3705SGra Flying Club LLC · Bay City, MIBuilt 1963 · S/N 17250905 N3705YMunoz Concepcion · Tulsa, OKBuilt 1963 · S/N 21058205 N3706UBrownfield Ken F · Boonville, MOS/N 18255106 N3706YAlexander Steve Craig · Shreveport, LABuilt 1963 · S/N 21058206 N3707DWilliams Charles S · Pearland, TXS/N 34407 N3707LPropwash Aviation LLC · Midland, MIBuilt 1965 · S/N 17253876 N3707RHartsfield Amy G · Pace, FLBuilt 1966 · S/N 17255507 N3708JBormann Wayne T · Valley Center, KSBuilt 1966 · S/N 15065008 N3708RNeufeld Henry F · Brownfield, TXBuilt 1966 · S/N 17255508 N3708SPalmer Christopher · Soddy Daisy, TNS/N 17250908 N3708UCollins George H · Murfreesboro, TNBuilt 1963 · S/N 18255108 N3709DAbidance Inc · Winthrop, WABuilt 1957 · S/N 34409 N3709FWeaver Jerry T Jr Trustee · Anchorage, AKBuilt 1966 · S/N 17255204 N3709JBoughter William C · Port Townsend, WAS/N 15065009 N3709RBaillie Stephen H · Flint, MIBuilt 1966 · S/N 17255509 N3709UMoser Scott M · Pisgah Forest, NCS/N 18255109 N370CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282000 N370ESPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280029 N370JCSouth Oaks Inc · Hollywood, FLBuilt 1977 · S/N U206-04024 N370JHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282191 N370K370k LLC · Bethany, OKBuilt 2026 · S/N 172S13481 N370LATurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251995 N370MEFlying Circuss Aviation Services Inc · Wasilla, AKBuilt 2000 · S/N 20608126 N370RAmerican Aircraft Management LLC · Irving, TXBuilt 1980 · S/N U20605501 N370SNesbit Stephen W · Hemphill, TXBuilt 1968 · S/N 17700692 N370SDGreat Cloud Design Inc · Dunedin, FLNon-citizen corporation, flight hours not reportedBuilt 1969 · S/N 69-7659 N370SPElite Approach LLC · Chesterfield, MOBuilt 2003 · S/N 172S9501 N370XPMckerney Charles A · Anchorage, AKBuilt 1976 · S/N 17267622

Back to AD 79-10-14 R1