Skip to content

Registered aircraft · 54,017

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.

N42150Custom Air Solutions LLC · Broadway, VABuilt 1968 · S/N 18258875 N42151Foster Floyd W · Lyon, MSBuilt 1968 · S/N 18258876 N42154Datil Fly Inc · Saint Augustine, FLBuilt 1968 · S/N 18258878 N42159Cutruzzula Arthur · Pittsburgh, PABuilt 1968 · S/N 18258881 N4215FBoss Brothers Aviation LLC · Buffalo, MOBuilt 1958 · S/N 46115 N4215UMaynard Paul E · Grand Junction, COBuilt 1964 · S/N 15060215 N4215VTriplett Taran R · Cheyenne, WYBuilt 1948 · S/N 18571 N42164Bush David W · Camden, NCBuilt 1968 · S/N 18258882 N4216LN4216l LLC · Kapolei, HIBuilt 1966 · S/N 17254285 N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040 N4216UNaeve James M · Renton, WABuilt 1963 · S/N 15060216 N42175Roberts Jason L · Crossville, TNBuilt 1968 · S/N 18258885 N42176N42176 LLC · Lynn Haven, FLBuilt 1968 · S/N 18258886 N42177Skydive Baltimore LLC · Churchville, MDBuilt 1968 · S/N 18258887 N42182Schaible John F · Palmerton, PABuilt 1973 · S/N 18052323 N42184Designed Cabinets · Lakeville, MNBuilt 1968 · S/N 18258890 N42188Verge Gregory J · Lynnwood, WABuilt 1968 · S/N 18258891 N4218FPerry Michael C · Edgewater, FLS/N 46118 N4218LWengs Enterprises Inc · Tustin, CABuilt 1966 · S/N 17254287 N4218QSavant John D · Kinder, LAS/N 17260118 N42198Johnson Steve · Belen, NMBuilt 1968 · S/N 18258894 N4219FHazellief Quillie J Jr · Okeechobee, FLBuilt 1958 · S/N 46119 N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119 N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437 N421TWHeslin Jon L · Sutton, MABuilt 1978 · S/N 18266268 N421YKearns Homer C III · Granbury, TXBuilt 1977 · S/N 18266133 N42202Palmer Charles L · Huntington Beach, CAFirst renewal noticeBuilt 1968 · S/N 18258895 N42204Conservation Aviation LLC · Washington, DCBuilt 1968 · S/N 18258897 N42206Jones Brian William · Portland, ORBuilt 1968 · S/N 18258899 N42209Smith Patrick G · Wenatchee, WABuilt 1968 · S/N 18258901 N4220FLeubner Karl T · Marietta, NYS/N 46120 N4220LDelordzia Mark · Columbia, NJBuilt 1966 · S/N 17254289 N4220QWhitefish Aero Services LLC · Crosslake, MNBuilt 1973 · S/N 18502225 N4220VMckinley Jason · Coulterville, ILBuilt 1948 · S/N 18576 N42212Caves Xxi Properties LLC · Virginia Beach, VABuilt 1974 · S/N 17264163 N42219Beck Daniel Joseph · Tuscaloosa, ALBuilt 1968 · S/N 18258908 N4221LSchram Ted K · Mukwonago, WIBuilt 1966 · S/N 17254290 N4221QRegistered aircraftBuilt 1971 · S/N 17260121 N4221UMcwilliams Robert P · Belgrade, MTBuilt 1964 · S/N 15060221 N4221VBashore Barry A · Pleasant Hill, OHBuilt 1948 · S/N 18577 N4222FBelford Zackery U · Elizabethtown, ILBuilt 1958 · S/N 46122 N4222LRtd Aviation LLC · Hillsborough, NJS/N 17254291 N4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYS/N 17260122 N42232Wheater Eric Alexander · King George, VABuilt 1968 · S/N 18258914 N42234Vp Niagara Aviation LLC · Niagara Falls, NYS/N 18258916 N4223LWolinski David T · Algonquin, ILBuilt 1966 · S/N 17254292 N4223VMcdermotts Letsfly LLC · Somerton, AZBuilt 1948 · S/N 18579 N42242Beats A Flush LLC · San Diego, CABuilt 1968 · S/N 18258920 N42247Kratz Jeffrey B · Seattle, WABuilt 1973 · S/N 18052330 N4224HWharton William R Jr · Dresden, OHBuilt 1978 · S/N 152-80324

Back to AD 87-20-03 R2