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.

N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040 N614KFGreat Ledge Development Inc · Saint Louis, MOBuilt 1977 · S/N 31-7752136 N6175ATiffin Aire Inc · Tiffin, OHBuilt 1979 · S/N 31T-7920011 N6190UCox Paul G · Bryce, UTBuilt 1974 · S/N 31-7401232 N619PREm Concordia Inc · Brooklyn, NYS/N 31-8052061 N61KBPegasus III LLC · Wilmington, DEBuilt 1981 · S/N 31-8152156 N620DBAlco Plane Co LLC · Memphis, TNBuilt 1979 · S/N 31T-7920055 N620RMCbs Inc DBA · Bellefontaine, OHS/N 31-7552040 N621AKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 31T1104014 N622AJYonder Corp · Wilmington, DEBuilt 1976 · S/N 31-7612083 N627MADestination Alaska Air Service LLC · Homer, AKBuilt 1975 · S/N 31-7512055 N62869Brown Henry H · Prospect, KYBuilt 1976 · S/N 31-7652145 N62898M & M Aircraft LLC · Cresson, TXS/N 317652157 N62899Sf Health Solutions Inc · Homestead, FLBuilt 1976 · S/N 31-7652122 N628HADigital Mapping Inc · Huntington Beach, CABuilt 1979 · S/N 31-7952085 N62912Gross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652164 N62923Gv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612093 N62992Light & Variable LLC · Arlington, VABuilt 1976 · S/N 31-7712013 N629RMW J Halberstadt Transportation Inc · Hartland, WIBuilt 1980 · S/N 31-8052197 N633D633d LLC · Miami, FLS/N 31-7852098 N63730Central Virginia Aviation Inc · North Dinwiddie, VAS/N 31-7752052 N63TTBrothers Aviation Va LLC · Manassas, VABuilt 1981 · S/N 31-8152026 N642WAGunnslinger Air LLC · Destin, FLBuilt 1979 · S/N 31-7952084 N643SCRegistered aircraftBuilt 1970 · S/N 31P-7 N645SCDeaton Dennis · Glen Allen, VAS/N 31P-22 N646SCRegistered aircraftBuilt 1970 · S/N 31P-33 N648SCDeaton Dennis · Glen Allen, VAS/N 31P-7300143 N649SCDeaton Dennis · Glen Allen, VAS/N 31P-7400184 N64APD&N Holdingsinc · Boca Raton, FLBuilt 1974 · S/N 31-7405178 N652PLN652pl LLC · Saint Joseph, MOBuilt 1980 · S/N 31-8052159 N652SCSale Reported · Glen Allen, VASale reportedBuilt 1970 · S/N 31P-14 N653SCDeaton Dennis · Glen Allen, VAS/N 31P-25 N6598LAtmospheric Corrosion Specialists Inc · Mechanicsburg, PABuilt 1969 · S/N 31-483 N65BATts Leasing Inc · Kansas City, KSBuilt 1980 · S/N 31T-8020071 N65CMCapital City Jet Center Inc · Somerset, OHBuilt 1978 · S/N 31-7852077 N660ACSmooth Air LLC · Richboro, PABuilt 1977 · S/N 31-7752142 N662CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 318052014 N668CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 31-8052176 N66AEAndreassi LLC · Bluffton, SCBuilt 1974 · S/N 31-7405187 N66ATDeer Elm Aviation LLC · Owens Cross Roads, ALBuilt 1975 · S/N 31-7552042 N66BGAlaska Island Air Inc · Togiak, AKS/N 31-8252032 N66TBTurner Brothers LLC · Middleboro, MABuilt 1983 · S/N 31-8452014 N66TWRolfe Bangerter Aviation LLC · Murray, UTS/N 31T-8004030 N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182 N676SAVincennes University · Indianapolis, INBuilt 1979 · S/N 31-7912122 N67DWDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 31T-7620041 N6890Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 31-7812003 N68BJCrownair LLC · Mansfield, PABuilt 1979 · S/N 31T7920029 N68WCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 31P-7400188 N696SGAtl Pilot LLC · Senoia, GABuilt 1984 · S/N 31-8452018

Back to AD 82-27-13 R2