Skip to content

Registered aircraft · 54,019

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.

N153SKWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281770 N153WSZeissner Douglas K · Chino, CABuilt 1952 · S/N 25355 N1540HFurtick Reginald D · Iuka, MSBuilt 1975 · S/N 177RG0714 N1540MClark Robert L Jr · Johnston, IABuilt 1975 · S/N 18264367 N1541DCentral Air Service Inc · Lewistown, MTBuilt 1952 · S/N 7763 N1541FRwr Air Inc · Tok, AKBuilt 1966 · S/N 185-0896 N1541HAtkin Cris R · St George, UTBuilt 1975 · S/N 177RG0715 N1541UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267169 N1542HCessna N1542h LLC · Fond Du Lac, WIBuilt 1975 · S/N 177RG0716 N1542MMelgaard Kenneth William · Minot, NDBuilt 1975 · S/N 18264368 N1542UWarner Walt M · Willow, AKBuilt 1973 · S/N U20602249 N1544EAtlas Aero Training LLC · Casper, WYBuilt 1978 · S/N 17271041 N1544HBaugh Ashton C · Petal, MSBuilt 1975 · S/N 177RG0718 N1545CGet Happy Adventures LLC · Leawood, KSBuilt 1953 · S/N 30245 N1545ESlipstream Aviation LLC · Carrollton, GABuilt 1978 · S/N 17271042 N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208 N1546CToney William M II · Gig Harbor, WABuilt 1953 · S/N 30246 N1546QInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 15072846 N1546VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263654 N1547MArtman John W · Lynnwood, WABuilt 1975 · S/N 18264371 N1547QAndersen Cameron T · French Gulch, CABuilt 1971 · S/N 15072847 N1547YBurgo Randy P · Alameda, CABuilt 1962 · S/N 17249247 N1548CRoy Flying Service LLC · Lettsworth, LABuilt 1953 · S/N 30248 N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722 N1549CDavidson Ron · Newfolden, MNBuilt 1953 · S/N 30249 N1549YLotwala Pathik · Woodbine, MDBuilt 1962 · S/N 17249249 N154BCTen Knot Tailwind LLC · Mesa, AZBuilt 1969 · S/N 21059157 N154DAOrr Lawrance C · Sacramento, CAS/N 15079253 N154EShupe John D · Solon Springs, WIFirst renewal noticeBuilt 1964 · S/N 15060707 N154EFAdams Donald C · Garner, NCBuilt 1968 · S/N 21059089 N154JBLevingston Brendan W · Denali Park, AKBuilt 1979 · S/N 15282685 N154SKReign Aviation LLC · Fresno, CABuilt 1978 · S/N 15282110 N154SWHigh Mountain Properties LLC · Idaho Falls, IDFirst renewal noticeBuilt 1975 · S/N 150-77204 N1550CGlidden Timothy J · Millinocket, MEBuilt 1953 · S/N 30250 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043 N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655 N1551DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 7773 N1551QJdn Plane LLC · Bellevue, WABuilt 1977 · S/N 18503484 N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656 N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726 N1552YRobinson Charles F · Beach City, TXBuilt 1962 · S/N 17249252 N1553HBuckner Robert M · Eufaula, OKBuilt 1975 · S/N 177RG0727 N1554CTaggart Brent W · Hydro, OKBuilt 1953 · S/N 30254 N1554FNovember 1554 Foxtrot LLC · Wilmington, DES/N 185-0921 N1555DSmith Michael D · North Myrtle Beach, SCBuilt 1952 · S/N 7777 N1555VGinther Michael P · Lemmon, SDBuilt 1974 · S/N 17263658 N1556MC-Fleet LLC · Missoula, MTBuilt 1971 · S/N 18800656 N1556VSquires Daniel Douglas · Wakefield, RIBuilt 1976 · S/N R1722201 N1557FFeaga Charles C Jr · Abbot, MEBuilt 1965 · S/N 185-0928 N1557HOpequon LLC · Vanderbilt, PABuilt 1975 · S/N 177RG0731

Back to AD 87-20-03 R2