Skip to content

Registered aircraft · 20,683

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N1812YHopkins Mark W · Emporia, KSBuilt 1962 · S/N 17249412 N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759 N1816YNicholas Thomas M II · Enid, OKBuilt 1962 · S/N 17249416 N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169 N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1997 · S/N 17280181 N181SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2016 · S/N 172S11663 N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385 N181TWTom Wood Aviation Inc · Fishers, INBuilt 2026 · S/N 172S13549 N1820EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12170 N1820VAsp Kenneth · Thief River Falls, MNBuilt 1974 · S/N 17263762 N1821YKinney James R · Vermillion, SDBuilt 1962 · S/N 17249421 N1823EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12171 N1825EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12172 N1825YRound Engine Aero · Nashville, MIS/N 17249425 N1826YSwensen James A · Lake Point, UTBuilt 1962 · S/N 17249426 N1828EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12173 N1828YPaulk Tracy · Fitzgerald, GABuilt 1962 · S/N 17249428 N182MASterling Flight Training LLC · Jacksonville, FLBuilt 2015 · S/N 172S11590 N182NWNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11043 N1830YKrug Kenneth C · Horton, KSBuilt 1962 · S/N 17249430 N1838EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12174 N1839EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12175 N183NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11083 N183RLJe Air LLC · Bayamon, PRBuilt 1973 · S/N 17261654 N183SPIndian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 172-68675 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N1841YSegroves Chris · Clarkston, WAS/N 17249441 N1842EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12176 N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769 N1845YAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1962 · S/N 17249445 N1846YMuldoon Anthony P · Howell, MIS/N 17249446 N1847YN1847y LLC · Queensbury, NYFirst renewal noticeBuilt 1962 · S/N 17249447 N184AFG & M Aircraft Inc · Wheat Ridge, COBuilt 2003 · S/N 17281184 N184NWNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11085 N1851YEscapule Dustin L III · Florence, AZBuilt 1962 · S/N 17249451 N1852YMinot Light Aviaiton LLC · Rockland, MABuilt 1962 · S/N 17249452 N1853YHurd Roger Mark · Bow, WABuilt 1962 · S/N 17249453 N1854VSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 17263771 N1854YMikowski Charles A · Sparta, MIS/N 17249454 N1857VCare Central Inc · Minneapolis, MNS/N 17263772 N1857YKnudson Wayne L · Larimore, NDBuilt 1962 · S/N 17249457 N1858YBlaich George F IV · Poplar Bluff, MOBuilt 1962 · S/N 17249458 N1859UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9927 N185CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13042 N1860YPeterson Jerad · Oshkosh, NES/N 17249460 N1862YVakalis Kevin A · Chugiak, AKBuilt 1962 · S/N 17249462 N1864VFrost Dennis J · Appleton, WIBuilt 1974 · S/N 17263774 N1864YHeckendorf Jon W · Ordway, COBuilt 1962 · S/N 17249464 N1868VCreative Strategies Inc · Proctorville, OHBuilt 1974 · S/N 17263775 N186CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13495

Back to AD 90-06-03 R1