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.

N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134 N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138 N7950BBobka Christian · Apple Valley, MNBuilt 1957 · S/N 29750 N7950GRotormate LLC · Royse City, TXBuilt 1970 · S/N 17259650 N7950TSchroeder Henry G · Lacombe, LABuilt 1960 · S/N 56650 N7950UBowden James E Jr · Eufaula, ALS/N 17251950 N79513Kalman Engineering Inc · Pekin, ILBuilt 1969 · S/N 17258142 N79514Galaxy Aviation LLC · Nantucket, MABuilt 1976 · S/N 17268134 N7951BRocky Creek Jbd Inc · Boca Grande, FLBuilt 1957 · S/N 29751 N7951TClair Brent A · Loraine, ILBuilt 1960 · S/N 56651 N7951URegistration Pending · New Smyrna Beach, FLRegistration pendingS/N 17251951 N79522729 Air LLC · Las Vegas, NVBuilt 1973 · S/N 18261832 N79526Evink Bradley D · North Branch, MNBuilt 1969 · S/N 17258151 N79529Elliott Tina L · Tucson, AZBuilt 1969 · S/N 17258154 N7952BEmaw Properties LLC · Ketchum, OKBuilt 1957 · S/N 29752 N7952FKagey Ryan D · Seabrook, TXBuilt 1966 · S/N 15064052 N7952GPlunkett Charles K E · Eagle Point, ORS/N 15074743 N7952TGregg John I Jr · Glendale, AZBuilt 1960 · S/N 56652 N7952UTigger II Airways LLC · Towson, MDBuilt 1964 · S/N 17251952 N79531Newberry Tyler D · Clovis, CABuilt 1969 · S/N 17258155 N79533Eby William J · Sugar Grove, ILBuilt 1969 · S/N 17258156 N7953BSavener Eric D · Kingsland, TXBuilt 1957 · S/N 29753 N7953GSnyder Kenneth C · Lonsdale, MNBuilt 1973 · S/N 15074744 N7953VRegistered aircraftBuilt 1967 · S/N 18051853 N79540Funk Kathryn A · Rockledge, FLBuilt 1969 · S/N 17258160 N79543Registration Pending · Manns Harbor, NCRegistration pendingBuilt 1969 · S/N 17258163 N79546Diakonis Emmanuel W · Maumee, OHBuilt 1969 · S/N 17258165 N79549Triad Aviation Academy LLC · Greensboro, NCBuilt 1969 · S/N 17258168 N7954FVikingland Flying Club · Alexandria, MNS/N 15064054 N7954GNo Squawks LLC · Newcastle, CABuilt 1970 · S/N 17259654 N79554Williams Kenneth J · Wasilla, AKBuilt 1969 · S/N 17258171 N79558Silver Creek Aviation Services LLC · Snowflake, AZBuilt 1969 · S/N 17258173 N7955BCochrane Geoffrey G · Seville, OHBuilt 1957 · S/N 29755 N7955FN7955f LLC · Titusville, FLS/N 15064055 N7955VHancock Glenn · Jackson, GABuilt 1967 · S/N 18051855 N79562Brown Glynna J · Middlesboro, KYBuilt 1969 · S/N 17258176 N79565Vm Aero LLC · Camden, DEBuilt 1969 · S/N 17258179 N79566Eisele Elton · Schaumburg, ILBuilt 1969 · S/N 17258180 N79567Miller Aviation Group LLC · Coon Rapids, MNBuilt 1969 · S/N 17258181 N7956FFios Flightline LLC · Tucson, AZBuilt 1966 · S/N 15064056 N7956USweeney Daniel N · Radcliff, KYBuilt 1964 · S/N 17251956 N7956XNesbit Stephen M · Chino Hills, CABuilt 1961 · S/N 17248456 N79571Myers James W · Westmoreland, NHS/N 17258185 N79575Fox Valley Flyers Inc · Appleton, WIBuilt 1969 · S/N 17258188 N79576Dillon Monte Lane Trustee · Mooresville, INBuilt 1969 · S/N 17258189 N79578Dannebrock Paul W · Lockport, NYBuilt 1969 · S/N 17258190 N79579Brown Larry · Mesa, AZS/N 17258191 N7957GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1970 · S/N 17259657 N7957XRoderick Ashley T Jr · Hixton, WIBuilt 1961 · S/N 17248457 N79580Bowers James H Jr · Broadus, MTBuilt 1969 · S/N 17258192

Back to AD 87-20-03 R2