Registered aircraft · 755

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:82-27-13-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-27-13-R2') 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:82-27-13-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-27-13-R2')
  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:82-27-13-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-27-13-R2')
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.

N1976JLock Haven Aircraft Sales · Lock Haven, PABuilt 1974 · S/N 31T-7520005 N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012 N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200PGPanther Enterprises LLC · Fort Myers, FLBuilt 1979 · S/N 31T-7920015 N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64 N200RARagan William W · North Kansas City, MOBuilt 1974 · S/N 31P7400198 N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054 N200TSSmith Ironworks Of Alabama LLC · Fort Payne, ALBuilt 1978 · S/N 31T-7804002 N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025 N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092 N20LXLockheed Martin Corporation · Palmdale, CABuilt 1975 · S/N 31-7552121 N20WLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1976 · S/N 31T-7720011 N212KSKilo Sierra LLC · Dodge City, KSBuilt 1979 · S/N 31T-7904010 N212RAAbin Ricardo · Miami Lakes, FLBuilt 1977 · S/N 317712057 N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011 N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117 N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122 N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078 N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126 N221ACAusten Air LLC · Lees Summit, MOBuilt 1980 · S/N 31-8152045 N222GWDodson International Parts Inc · Rantoul, KSS/N 31T-7904050 N225CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 31T-8104024 N225TMSouth Of Snow Adventures LLC · Hartwell, GAS/N 318152165 N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198 N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184 N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085 N227TMMed Care Inc · Grand Island, NES/N 31T-7400008 N22AWAir What What LLC · Clackamas, ORBuilt 1979 · S/N 31T-7920059 N22WFBemidji Aviation Services Inc · Bemidji, MNBuilt 1978 · S/N 31T-7920007 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062 N233PSDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7820039 N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203 N234PLCole Steven David · Saint Petersburg, FLS/N 31P-7300147 N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073 N242GG242gg LLC · Wilmington, DEBuilt 1979 · S/N 31-7952080 N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025 N244ABParton Aviation Co LLC · Rutherfordton, NCBuilt 1979 · S/N 31T-8004015 N2458WBig Bend Outdoor Center LLC · Pittsburg, TXBuilt 1979 · S/N 31T-8004017 N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049 N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045 N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N253DSIpmad Vpmc Aerial Mosquito Control · New Iberia, LABuilt 1980 · S/N 31-8052142 N2556RRed Willow Rescue Inc · Cooperstown, NDBuilt 1979 · S/N 31T-8004003 N257SHDodson International Parts Inc · Rantoul, KSS/N 31-8052121 N262ASAerodata LLC · Ann Arbor, MIBuilt 1977 · S/N 31-7712102 N262LRValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 31T8104002 N26GPGpi Geospatial Inc · Orlando, FLBuilt 1977 · S/N 31-7812001 N271ABHoney Badger LLC · Tulsa, OKBuilt 1979 · S/N 31T-7904024 N271ASSkattum LLC · Sioux Falls, SDBuilt 1976 · S/N 31-7612073

Back to AD 82-27-13 R2