Skip to content

Registered aircraft · 54,015

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N65770Thompson Clinton J · Greer, SCBuilt 1982 · S/N 17275874 N65772Sky Adventure LLC · Bartlett, TNBuilt 1982 · S/N 17275875 N65773Ial Corp · Lewes, DEBuilt 1982 · S/N 17275876 N65775Ristrim Eric · Henderson, NVBuilt 1982 · S/N 17275878 N65776Meridian Aviation Holding Company · Teterboro, NJBuilt 1982 · S/N 17275879 N6577ANafus Gifford William · Palmer, AKBuilt 1956 · S/N 32474 N6577DScootair LLC · Alburgh, VTS/N 7847 N6577HRegistered aircraftBuilt 1975 · S/N 17265496 N6577QForce Gary · Granbury, TXBuilt 1981 · S/N 15285275 N6577RAir Echo Alpha 51 LLC · Erie, COBuilt 1979 · S/N 172RG0203 N65784Ohio State University · Columbus, OHBuilt 1982 · S/N 17275884 N65789Burket George C · North Hollywood, CABuilt 1982 · S/N 17275888 N65798Samons David M · Phoenix, AZBuilt 1982 · S/N 17275894 N6579ESkinner William T III · Little Rock, ARBuilt 1959 · S/N 56079 N6579FPratka Rhett A · Pleasanton, TXBuilt 1966 · S/N 15063179 N657SCKruse Shannon E · Republic, MOBuilt 1973 · S/N 177RG0301 N657SRRm & Lp Ltd · Azalea, ORBuilt 1968 · S/N 17701019 N6580AHelleloid Kristen L · Intl Falls, MNBuilt 1956 · S/N 32477 N6580EReady Aim Flyer LLC · New Castle, DEBuilt 1959 · S/N 56080 N6580FLawson Jeremiah · Lunenburg, VTBuilt 1966 · S/N 15063180 N6580GMonskey David Paul · Minnetonka, MNBuilt 1970 · S/N 15072080 N6580LHigh Wing Air Services LLC · Merritt Island, FLBuilt 1980 · S/N 15284446 N65813Northwest Wings LLC · Hillsboro, ORBuilt 1983 · S/N 17275896 N65815Montgomery David A · Mancelona, MIS/N 17275897 N6581GCox Martin S · Greenwood, INBuilt 1970 · S/N 15072081 N6581VSimmons Claude E · Ocracoke, NCBuilt 1980 · S/N 172RG0777 N65821Goodley Scott Val · Denton, TXBuilt 1982 · S/N 17275899 N6582AN6582a Leasing Service LLC · Wasilla, AKBuilt 1956 · S/N 32479 N6582FHemmatyar Nabi Z · Malibu, CAS/N 15063182 N6582MHayward W Blair · Brooks, GAS/N 18263764 N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191 N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958 N6583FButterfield Rory A · Milan, NMS/N 15063183 N6583GRusch Steven A · Sequim, WABuilt 1970 · S/N 15072083 N6583MParnell Kevin T · Buhl, IDBuilt 1975 · S/N 18263765 N65842Holladay Aviation LLC · Jacksonville, FLBuilt 1983 · S/N 17275906 N6584AWildman Air LLC · Mckinney, TXBuilt 1956 · S/N 32481 N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112 N6585FBrouse Dan T · Magnolia, TXBuilt 1966 · S/N 15063185 N6585GPace Glen M · Columbia, MSBuilt 1970 · S/N 15072085 N65866Planenutz LLC · Deland, FLBuilt 1983 · S/N 17275908 N6586EJordan Sidney G · Wasilla, AKBuilt 1980 · S/N 18504057 N6586FLunar Aviation LLC · Tahlequah, OKBuilt 1966 · S/N 15063186 N6586HOracle Aviation LLC · Omaha, NEBuilt 1975 · S/N 17265498 N6586SMiller William H · Live Oak, FLS/N 15067386 N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800 N65872Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275909 N6587ADuncan William K · Collierville, TNBuilt 1956 · S/N 32484 N6587EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272040 N6587FJones Aviation Inc · Biggs, CABuilt 1966 · S/N 15063187

Back to AD 87-20-03 R2