Skip to content

Registered aircraft · 54,017

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.

N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034 N513International Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N 33701572 N51300Loftin Gabe · Weatherford, TXBuilt 1977 · S/N 177RG1137 N51304Stewart Roy L · Roy, UTS/N 15069909 N51306Durand Gregory M · Marquette, MIBuilt 1968 · S/N 15069911 N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280 N5130EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271725 N5130RShamp Jimmy L · Fresno, CABuilt 1974 · S/N 17263347 N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087 N51314Scott John J · Arcadia, FLBuilt 1968 · S/N 15069916 N51316Devault Clayton D · Larkspur, COS/N 15069918 N51317Spitzer Terry E · Kalona, IAS/N 15069919 N5131AJohnson Basil · Tucson, AZBuilt 1955 · S/N 28131 N5131EBrunken Barry D · Tower Hill, ILBuilt 1978 · S/N 17271726 N5131FWoerle Edward R · Rossville, TNBuilt 1965 · S/N 17252888 N5131NPiedmont Aircraft LLC · North Myrtle Beach, SCBuilt 1980 · S/N 18267538 N5131QLeavitt Craig S · Spicewood, TXBuilt 1972 · S/N 21059631 N5131RMlt Operations LLC · Traverse City, MIBuilt 1974 · S/N 17263348 N5131T3b'S Land Development LLC · Seattle, WAS/N R18201821 N51323Rathnayake Eric · Collegeville, PABuilt 1968 · S/N 15069924 N51326Lapoint Paul E · Drummond Island, MIBuilt 1968 · S/N 15069926 N51327Bowles Alan B · Georgetown, TXBuilt 1968 · S/N 15069927 N51328Butterfield Charles D · Eskridge, KSBuilt 1968 · S/N 15069928 N5132EFicklin Thomas L · Fairbury, ILBuilt 1959 · S/N 50432 N5132HMohnacs Joseph T · Mount Laurel, NJBuilt 1975 · S/N 17265347 N5132QHauptman Ben · Alexandria, VABuilt 1973 · S/N 17261760 N5132ULiberty Exploration Inc · Las Vegas, NVS/N 172RG0250 N51330Cortez Flying Service Inc · Cortez, COBuilt 1980 · S/N 17274298 N51333Blazey John Stanley · Palmyra, NYBuilt 1968 · S/N 15069930 N51334Cragg Noel J · Millbrae, CABuilt 1968 · S/N 15069931 N51337Garner Charlotte Trustee · Sun Lakes, AZS/N 15069933 N5133ALake Area Technical Institute · Watertown, SDBuilt 1955 · S/N 28133 N5133DPalmer Ross G · Las Cruces, NMBuilt 1958 · S/N 51233 N5133GPioneer Aviation LLC · Crossett, ARBuilt 1969 · S/N 17258447 N5133QReed Aero Group LLC · Hendersonville, TNBuilt 1973 · S/N 17261761 N51343Tucker John D II · Fayetteville, GABuilt 1968 · S/N 15069939 N51345Arizona Aircraft Leasing LLC · Mesa, AZS/N 15069941 N51347Bernhardt Michael J · North Branch, MNS/N 15069942 N5134DWheeler Robert L · Nampa, IDBuilt 1958 · S/N 51234 N5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationBuilt 1969 · S/N 17258448 N5134KSunrise Aviation LLC · Gilbert, AZBuilt 1980 · S/N 17273979 N5134WPlane Fun Inc Tr Trustee · Snellville, GAS/N P21000643 N51355Miller Judith A · Homer, AKS/N 15069946 N5135BMekkes Gregory L · Norfolk, VAS/N 18400 N5135ECommercial Safe And Lock Inc · Imperial, MOBuilt 1978 · S/N 17271728 N5135GChinrock Adam · Spanish Fort, ALBuilt 1969 · S/N 17258449 N5135QOlivas Frank · Fabens, TXBuilt 1965 · S/N 17252916 N51365Cavu Pilot LLC · Powell, TNBuilt 1968 · S/N 15069953 N51367Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 15069954 N51369Thorn Blake A · Coupeville, WAS/N 15069956

Back to AD 87-20-03 R2