Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N336NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 120M N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140 N336RABrown Donald B · Virginia Beach, VABuilt 1978 · S/N 3098 N336RVVose Kristin M · Bloomington, ILBuilt 2001 · S/N 60199 N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489 N336SGAndrade South Florida Services Inc · Plantation, FLS/N 1336 N336TAElder Stephen D · Prineville, ORBuilt 2008 · S/N 22562 N336VRobertson Ryan T · Richmond, VABuilt 1979 · S/N 79-31155 N336WTRomney Chad · Rigby, IDBuilt 2023 · S/N 1210-2023 N3370AHospodar Robert P · Georgetown, PAS/N 22-1627 N3370MPetrie Charles W III · Pahala, HIBuilt 1947 · S/N 12-2242 N3370WRaddohl Garret L · New London, MNS/N 32-216 N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231 N3371BEllis William Cole · Gakona, AKFirst renewal noticeBuilt 1954 · S/N 18-3494 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3371RRs Helicopters Inc · Winter Haven, FLS/N 3371 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N33727Cohran Chuck Earl · Bowdon, GABuilt 1975 · S/N 28-7515358 N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173 N3372BRegistration Pending · Fairbanks, AKRegistration pendingBuilt 1954 · S/N 18-3496 N3372MFarah Michael J · Mclean, VABuilt 1980 · S/N 28-8011059 N3372XLeahy David J · Delaware, OHBuilt 1966 · S/N 670028 N3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeBuilt 1960 · S/N 18-7245 N33733Swink Cory A · Gold Hill, NCBuilt 1975 · S/N 28R-7535184 N33735Mcenaney John E · Orlando, FLBuilt 1975 · S/N 28-7510058 N33745Hunt Joel P · Berlin, WIBuilt 1975 · S/N 28-7515359 N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175 N3374ASinosky Kendall Ansley · Anchorage, AKS/N 22-1631 N3374BFederico Leonard A · Reno, NVBuilt 1954 · S/N 183502 N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374WMcfadyen Joseph P · Florence, SCS/N 32-220 N3374XLee Rollin Kim · Panaca, NVS/N 1091 N3374ZKing Paul E · Albany, ORBuilt 1959 · S/N 18-7249 N33750Geek Air LLC · Wilmington, NCBuilt 1975 · S/N 28R-7535187 N33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDBuilt 1975 · S/N 28-7515360 N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176 N33759Flight Time Club LLC · Searcy, ARFirst renewal noticeBuilt 1975 · S/N 28R-7535188 N3375ATatalovich George · Rome, OHS/N 22-1628 N3375MScott Rudee L · Anchorage, AKBuilt 1947 · S/N 12-2224 N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235 N33763Elon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515361 N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178 N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380 N33770Bassett Christopher D · Robbinsville, NCS/N 28R-7535191 N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180 N3377ABuller Wilbur D · Redding, CABuilt 1953 · S/N 22-1632 N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337 N3377XPenalo Garcia William J · Toa Baja, PRBuilt 1966 · S/N 1092 N3377ZMorris David S · North Pole, AKBuilt 1960 · S/N 18-7258

Back to AD 81-18-04 R2