Skip to content

Registered aircraft · 18,497

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

N53032Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1974 · S/N 18502326 N5303XRedemption Inc · Kodiak, AKBuilt 1980 · S/N U20605622 N53044Trophy Down LLC · Punta Gorda, FLBuilt 1973 · S/N 18502334 N53046Tucker Thomas G · Dillingham, AKBuilt 1973 · S/N 18502336 N53055Echo Lake Air LLC · Soldotna, AKBuilt 1974 · S/N 18502343 N53057Endsley Gregory C · Sterling, AKBuilt 1974 · S/N 18502345 N53059Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1974 · S/N 18502347 N53083Clearwater Potlatch Timber Protect · Orofino, IDBuilt 1974 · S/N 18502367 N53092Reilly Patrick M · Anchorage, AKBuilt 1974 · S/N 18502371 N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927 N530ESki N Sky LLC · Leesburg, VABuilt 2003 · S/N 0575 N530WELathrop Frederic W · Dayton, OHBuilt 2013 · S/N 53 N53105Pence Dale E · Garnett, KSBuilt 1974 · S/N 18801625T N5310KSale Reported · Vineyard, UTSale reportedBuilt 1950 · S/N NAV-4-2210B N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862 N5314VBurke Sterling M · Olympia Fields, ILBuilt 1975 · S/N 21060905 N5314XMoody Bible Institute Of Chicago · Spokane, WAS/N U20605633 N5315XAtarah LLC · Tucson, AZBuilt 1980 · S/N U20605634 N5316JCocola Gary M · Fresno, CABuilt 1977 · S/N 340A0405 N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365 N5317RHayton James B · Sedro Woolley, WAS/N 18503031 N53183Allred Gina D Administrator · Centre, ALBuilt 1974 · S/N 18801668T N5318ABuchanan Harvey · Townsend, MABuilt 1979 · S/N 21063366 N5318VTyson Ron A · Fredericksburg, TXBuilt 1975 · S/N 21060906 N531ABMissionair Inc · Danbury, CTS/N TJ-454 N531BFLouis F Olberding Dds Pc · Lincoln, NEBuilt 1973 · S/N D-9541 N531CDSasha Rose Express LLC · Scottsdale, AZBuilt 2005 · S/N 1622 N531ECBlue Jets LLC · Rialto, CABuilt 1981 · S/N P21000725 N531HAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1968 · S/N 185-1348 N531KCConstantine LLC · Fort Collins, COBuilt 1985 · S/N TH-1484 N531MHigh Cotton Aero LLC · Murray, KYBuilt 1978 · S/N 340A0534 N531UArizona Air Transport LLC · Mesa, AZBuilt 1966 · S/N TE-104 N5320JCorporate Air Charter Inc · Wilmington, DEBuilt 1977 · S/N 340A0407 N53211Anderson Aerial Spraying Service Inc · Canby, MNS/N 18801688T N53220Sidekick Aviation LLC · Tuscaloosa, ALBuilt 2004 · S/N 0865 N53227Birddog Aviation LLC · Stockton, KSBuilt 1974 · S/N 18801699T N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865 N53243Fly Low Aviation LLC · Ashley, NDBuilt 1974 · S/N 18801706T N53245Kirk Ben C · Louisville, MSBuilt 1974 · S/N 18801708T N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0410 N53252Bos John D · Locust Grove, GABuilt 1977 · S/N 310R1219 N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164 N53277Petecraft Aviation Services Inc · Plains, GABuilt 1974 · S/N 18801732T N5328JKahler Automation Corp · Fairmont, MNBuilt 1977 · S/N 340A0412 N53297Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2004 · S/N 0898 N532CHall Brian · Yuma, AZBuilt 2002 · S/N EA-691 N532CHWhedbee Donald Justin · Conroe, TXBuilt 1980 · S/N P21000501 N532DGRio Farms LLC · King City, CABuilt 1983 · S/N P21000829 N532EBlue Pointe Aviation LLC · Valparaiso, INBuilt 1989 · S/N CE-1377 N532EBJeb Air LLC · Waverly, OHBuilt 1980 · S/N 414A0440

Back to AD 86-13-04 R3