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.

N3395DFitzgerald John A Jr · Ester, AKBuilt 1955 · S/N 32193 N3395JFly N Style · Parkland, FLBuilt 1967 · S/N 15066095 N3395RJohnston Osceola Holdings LLC · Dallas Center, IABuilt 1968 · S/N 18258695 N3395YTriple J Aviation · East Quogue, NYS/N 18254395 N3396FThompson Patrick J · Evanston, WYBuilt 1966 · S/N 18257396 N3396RSimmons Craig · Houston, TXBuilt 1967 · S/N 18258696 N3396VHarvey Christopher J · Port Leyden, NYBuilt 1974 · S/N 15076488 N3396YPlane Fun Inc · Lewes, DEBuilt 1962 · S/N 18254396 N3397FKerns Aaron R · Sullivan, INBuilt 1966 · S/N 18257397 N3397JZwerko Sherri · South Plainfield, NJBuilt 1967 · S/N 15066097 N3397RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1967 · S/N 18258697 N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197 N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697 N3398YBobbitt Michael · Lamont, OKBuilt 1962 · S/N 18254398 N3399FVetter T Kevin Trustee · Phoenix, AZBuilt 1966 · S/N 18257399 N3399LMetz William · Laurel, MTS/N 185-1351 N3399RGleason Joseph P · Knoxville, TNBuilt 1967 · S/N 18258699 N3399UWorley Dan J · Perris, CABuilt 1963 · S/N 18254799 N339CHPitch And Power LLC · Indianapolis, INBuilt 1977 · S/N 18265213 N339CPHenley Mark L · Emelle, ALBuilt 1966 · S/N 18257470 N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119 N339MEShinkle Gordon · Gillette, WYBuilt 2000 · S/N 18280734 N339MSMile And A Half High LLC · Sarasota, FLS/N 21062036 N339SABig River Farms Inc · Natchez, MSBuilt 1999 · S/N 18280508 N339SPCahill Michael · Moon Township, PABuilt 2003 · S/N 172S9496 N33AGSory Bailey B IV · Bozeman, MTS/N 21061637 N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632 N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989 N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451 N33DMGray Chad T · Garden Valley, IDBuilt 1968 · S/N 18259170 N33DPB&C Cejka Real Estate LLC · Sioux City, IABuilt 1967 · S/N 15066465 N33EEDes Moines Skydivers LLC · Des Moines, IABuilt 1969 · S/N 18259998 N33FCReece Trucking And Excavating Inc · Marysville, WAS/N 18501631 N33FMAtp Aircraft 7 LLC · Wilmington, DEBuilt 2012 · S/N 172S11196 N33GCMarble Jere D · Dayton, NVBuilt 1954 · S/N 30913 N33GJOliser Andras · Savannah, GABuilt 1964 · S/N 205-0538 N33HARykris Investments LLC · Bowling Green, KYBuilt 2011 · S/N 18282279 N33JHRoelfs Vernon L · Eagle River, AKFirst renewal noticeBuilt 1977 · S/N 185-03410 N33KRAviaschin LLC · Frisco, TXBuilt 1978 · S/N 18266595 N33KYBurnette Ric A · Sebastian, FLS/N 17253910 N33LAOscar Tango LLC · Mesa, AZBuilt 2020 · S/N 172S12446 N33MGTopeka Flyers Inc · Topeka, KSBuilt 1969 · S/N 18259660 N33MLDaedalean Inc · Chandler, AZBuilt 1978 · S/N 18266626 N33NRLuis Antonio · Miami Springs, FLBuilt 1979 · S/N 18267415 N33REChapman Richard B · Granbury, TXBuilt 1969 · S/N 18259682 N33RNMurphey John L · Fredericksburg, VABuilt 1964 · S/N 21058533 N33SQJohnston H Kenneth II · Wheatland, WYBuilt 1966 · S/N T210-0056 N33UT402wd Holdings LLC · Corpus Christi, TXS/N 21061177 N33VERotermund Brett L · Fairbanks, AKBuilt 1976 · S/N 18503007

Back to AD 79-10-14 R1