Skip to content

Registered aircraft · 85,616

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N12671Beaver Valley Flying Club Inc · Albion, NEBuilt 1973 · S/N 17262163 N12676Berry Victor A · Ashburnham, MABuilt 1973 · S/N 17262167 N12678Zma LLC · North Little Rock, ARBuilt 1973 · S/N 17262169 N12679Garuda Aviation Inc · Miami, FLBuilt 1973 · S/N 17262170 N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N1267RMurrell James F Sr · Douglas, AZBuilt 1971 · S/N 30403 N1267SWhitmore James W · Grass Valley, CABuilt 1976 · S/N 18264835 N1267USms Aviation Company · Wilmington, DEBuilt 1976 · S/N 17266962 N1267ZN1267z LLC · Indianapolis, INBuilt 1961 · S/N D-6707 N12682Magish Matthew · Fleming Island, FLBuilt 1973 · S/N 17262172 N12683Sale Reported · Hillsboro, ORSale reported, pending cancellationBuilt 1973 · S/N 17262173 N12684Alvidrez Investments LLC · Lakewood, CABuilt 1974 · S/N 17262174 N12687Davies Kenneth A · Oak Harbor, WABuilt 1973 · S/N 17262177 N1268MHuffer Tyle · Kenansville, NCBuilt 1975 · S/N 18264266 N1268TFortney Thomas Kent · Humble, TXBuilt 1972 · S/N 28-7225444 N1268ZTodd Cori L · Gladewater, TXBuilt 1961 · S/N TC-84 N12692Chouinard Kenneth W Jr · Norton, MABuilt 1973 · S/N 17262181 N12694Dicentes James P · Leicester, MABuilt 1973 · S/N 17262183 N12698American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262187 N1269MEagle High Properties LLC · Calhoun, LABuilt 1975 · S/N 18264267 N1269SMriaudio Inc · Carlsbad, CAS/N 18264837 N1269ZChilds Lowell R · Elgin, ILBuilt 1961 · S/N TC-85 N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772 N126BERekast Flying Services Inc · Englewood, FLBuilt 1992 · S/N 24-3248 N126DAWhite Drew C · Granbury, TXBuilt 1978 · S/N 17270977 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N126GLN126gl LLC · Roca, NEBuilt 1975 · S/N E-763 N126HBockman Ltd · Milford, IABuilt 1967 · S/N D-8544 N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878 N126JCGebler Laurence W · Ellerbe, NCBuilt 1979 · S/N 18267134 N126KWersinger Duncan · Rochester, NYFirst renewal noticeBuilt 1968 · S/N 17257392 N126LMMatt Aviation Propertis Inc · Nashua, NHBuilt 2003 · S/N 3257336 N126LSMerritt Aaron S · Manhattan, MTS/N 21062038 N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865 N126MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496481 N126MPSorensen P Grahame · Salt Lake City, UTBuilt 1974 · S/N 18262809 N126MSNance Cattle Co · Birney, MTBuilt 1964 · S/N 18051373 N126PCRoots & Wings Aviation LLC · West Simsbury, CTBuilt 1979 · S/N 32R-8029042 N126PFPylant Ruth A · Lubbock, TXS/N 30-1122 N126PKPtk Equipment Inc · Miami Lakes, FLBuilt 2005 · S/N 3257390 N126SWollaston Dean E · Hazel Green, WIBuilt 1956 · S/N 33285 N126SAS2 Aviation LLC · Biloxi, MSBuilt 1959 · S/N D5817 N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126 N126TMFlynfish Air LLC · Rome, GAS/N 310R1231 N126TWAerial Advertising Services · San Jose, CABuilt 1972 · S/N 17260900 N126WGN126wg LLC · Oak Brook, ILBuilt 1972 · S/N D-9315 N126WWAircraft Holdco LLC · San Diego, CABuilt 1998 · S/N 24-3431 N12701Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262189 N12702Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1973 · S/N 17262190 N12704Charlie Lima 1 LLC · Jacksonville, FLBuilt 1973 · S/N 17262192

Back to AD 98-21-21 R1