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.

N6759RRegistered aircraftS/N T210-0159 N67601Aero Maintenance Inc · Vancouver, WABuilt 1978 · S/N 15281939 N6760FClancy Mackenzie W · Grand Rapids, MIS/N 15063360 N6760GPurkinje Ltd LLC · Wilmington, DEBuilt 1970 · S/N 15072260 N6760SPantera Services LLC · New York, NYBuilt 1967 · S/N 15067560 N67611Kumor Ronald G · Casper, WYBuilt 1978 · S/N 15281945 N67614Wampus Cats Inc · Davenport, IABuilt 1978 · S/N 15281948 N67618Hale Douglas W · Perryton, TXBuilt 1978 · S/N 15281950 N6761ASkeen Steven L · Enterprise, ALBuilt 1956 · S/N 28861 N6761RPerini Mark J · Greenleaf, IDBuilt 1966 · S/N T210-0161 N6761TMccarville Katherine A · Fayette, IABuilt 1960 · S/N 47261 N6762EMeyer Nicholas · Waverly Hall, GABuilt 1959 · S/N 56262 N6762SRegistration Pending · Snowflake, AZRegistration pendingBuilt 1967 · S/N 15067562 N67638Blue Feathers Corp · Newark, DEBuilt 1978 · S/N 15281954 N6763FLogsdon Dale L Trustee · Alva, OKS/N 15063363 N6763GVarner David L · Eastpoint, FLS/N 15072263 N67648Flying Vikings Inc · Hayward, CABuilt 1978 · S/N 15281960 N6764FBruno Alfred T · Santa Rosa, CABuilt 1966 · S/N 15063364 N6764MKahuna Sky LLC · Howell, MIBuilt 1975 · S/N 18263828 N67651Salomonsson Mats · Fremont, CABuilt 1978 · S/N 15281963 N67652Final Design Group LLC · Hurricane, UTBuilt 1978 · S/N 15281964 N67657Jade Air LLC · San Pedro, CABuilt 1978 · S/N 15281965 N6765ANiehues Reid B · Eola, TXBuilt 1956 · S/N 28865 N6765SMaxson Gerald · Hawthorne, FLBuilt 1967 · S/N 15067565 N6766ADenton Michael W · Clarksville, VABuilt 1956 · S/N 28866 N6766FAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1966 · S/N 15063366 N6767GAspen Kelsen LLC · Rutledge, MOBuilt 1970 · S/N 15072267 N6768EHeifner Gary E · Conway, ARS/N 56268 N67695Lynch Robert F · Mount Vernon, OHBuilt 1967 · S/N R172-0152 N6769ELingo Grant W · Beaumont, TXBuilt 1959 · S/N 56269 N6769FGarvey Aviation Services · Erie, PABuilt 1966 · S/N 15063369 N6769RDomingues Silvio · Woodland, ALBuilt 1966 · S/N T210-0169 N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905 N676DCPrinc Aviation LLC · Beloit, KSBuilt 1972 · S/N 18261020 N67701R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281969 N67705Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15281971 N67708Pischel Tom K · Meadow Vista, CABuilt 1978 · S/N 15281974 N6770AHele David A · Birchwood, WIBuilt 1956 · S/N 28870 N6770EKoyle Bruce Ronald · Rancho Cucamonga, CABuilt 1959 · S/N 56270 N6770FFaith Tabernacle Ministries Inc · Junction City, KSBuilt 1966 · S/N 15063370 N67710Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281975 N67711Cox Linda M · Christiana, TNFirst renewal noticeBuilt 1978 · S/N 15281976 N6771EKlingman Matthew W · Chappell, NEBuilt 1959 · S/N 56271 N67728Edj Aviation Ltd · Fort Myers Beach, FLBuilt 1978 · S/N 15281983 N6772FIrlbeck Cyler M · Eden Prairie, MNBuilt 1966 · S/N 15063372 N67733Righter Douglas D · Bellingham, WABuilt 1978 · S/N 15281986 N6773MLake Erie Aviation LLC · Lyndhurst, OHBuilt 1975 · S/N 18263830 N67746Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15281992 N6774ERegistration Pending · Crystal, MNRegistration pending, pending cancellationBuilt 1959 · S/N 56274 N6774SBennington Aaron G · Delaware, OHBuilt 1967 · S/N 15067574

Back to AD 87-20-03 R2