Skip to content

Registered aircraft · 806

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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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.

N59777Sofisa Airways Corp · Coral Gables, FLBuilt 1976 · S/N 31-7612020 N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037 N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027 N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N59EHSale Reported · Dawsonville, GASale reported, pending cancellationBuilt 1978 · S/N 31T7820014 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N5DValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 31T-7820080 N601AJShamrock Aviation LLC · Madison, MSBuilt 1984 · S/N 31T-1104013 N606DWElkhorn Valley Trucks II LLC · Fremont, NEBuilt 1981 · S/N 31T-8120038 N606JSStar Marianas Aviation School Inc · Tinian, MPS/N 31-7952145 N60AY2701 Ne 27 Court LLC · Hollywood, FLBuilt 1981 · S/N 31-8152051 N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60JWTumbleweed Leasing LLC · Tacoma, WABuilt 1980 · S/N 31T-8004031 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N6107AR & R Aviation Support LLC · Atlanta, GABuilt 1978 · S/N 31T-7820087 N611BT-2 Enterprises LLC · Walla Walla, WABuilt 1981 · S/N 31T-8166015 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, OHFirst renewal noticeS/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 N630MWDmp II LLC · Kissimmee, FLS/N 31T-8166011 N632CBIou Aviation Of Montana LLC · Sheridan, WYBuilt 1983 · S/N 31T8166066 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

Back to AD 93-24-02 R1