Skip to content

Registered aircraft · 81,720

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.

N201QJDubritz Michael J · Dix Hills, NYBuilt 1977 · S/N 24-0347 N201QLBuchholz Michael S · West Hamlin, WVBuilt 1986 · S/N 24-1604 N201QMNordica Group Ltd · Chicago, ILBuilt 1977 · S/N 24-0339 N201QRJennings Denise E Trustee · Fullerton, CABuilt 1977 · S/N 24-0353 N201QUModen Aircraft Inc Trustee · Wilmington, DEFirst renewal noticeBuilt 1991 · S/N 243216 N201QVJohnson Philip H · Bluffton, SCS/N 24-0355 N201QWRose James D · Fort Worth, TXS/N 24-0236 N201QXRegistration Pending · Portland, ORRegistration pendingBuilt 1977 · S/N 24-0367 N201QYJohnson Seth M · Arlington, TXBuilt 1977 · S/N 24-0357 N201QZFogle Adventure Air LLC · Neeses, SCS/N 24-0358 N201RMay Jack C · Conroe, TXBuilt 1977 · S/N 24-0203 N201RAMooney 201ra Holding LLC · San Diego, CABuilt 1982 · S/N 24-1319 N201REFowler W Kirk · Longmont, COBuilt 1977 · S/N 24-0341 N201RFMfc Corp · Washington, DCS/N 24-0135 N201RJLoyless John B · Lubbock, TXBuilt 1977 · S/N 24-0115 N201RLGmg Associates · Madison, CTBuilt 1977 · S/N 24-0143 N201RRGuthrie Edward J · Lincoln Univ, PABuilt 1977 · S/N 24-0089 N201RSWilliams Ken L · Palmer, AKBuilt 1976 · S/N 24-0062 N201RUMoore James B · Yorktown, VAS/N 24-0360 N201RWRodriguez Ricardo A · Norristown, PAS/N 24-0158 N201RYTop Shelf LLC · West Fargo, NDBuilt 1977 · S/N 24-0257 N201RZGoller Daniel M · Grass Lake, MIBuilt 1977 · S/N 24-0327 N201SAQuinn Timothy M · South Haven, MIBuilt 1977 · S/N 24-0114 N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630 N201SGPhoturis LLC · New Carlisle, OHBuilt 1977 · S/N 24-0178 N201SKBu James · South Pasadena, CABuilt 1977 · S/N 24-0142 N201SLCooley Ben · Owensboro, KYBuilt 1977 · S/N 24-0191 N201SNBecker Dean · Sarasota, FLBuilt 1977 · S/N 24-0319 N201SQThomas John M · Lake Lure, NCBuilt 1977 · S/N 240298 N201STTillman Stephen · Jacksonville, FLBuilt 1977 · S/N 24-0201 N201SVBrown Elijah E · Chino Valley, AZBuilt 1977 · S/N 24-0301 N201SWMccrea Alice · Albuquerque, NMS/N 24-0188 N201SZRacoon Aviation LLC · San Antonio, TXS/N 24-0285 N201TMerten James F · Oshkosh, WIBuilt 1970 · S/N 186 N201TAAdams Toby R · Paris, TXBuilt 1977 · S/N 24-0291 N201TCInternational Lift Planning Inc · Anaheim, CABuilt 1977 · S/N 24-0173 N201TDHasenauer Matthew R · North Platte, NEBuilt 1977 · S/N 24-0307 N201TEBest Power Inc Trustee · Wilmington, DEBuilt 1977 · S/N 24-0289 N201TJPalmetto Moon Light Services LLC · Mount Pleasant, SCBuilt 1977 · S/N 24-0306 N201TKUp Aerospace LLC A Series Of · Georgetown, TXBuilt 1976 · S/N 24-0048 N201TLPiorkowski Christian E · Pearland, TXBuilt 1977 · S/N 24-0202 N201TMTrujillo John Francisco · Newport News, VABuilt 1978 · S/N 24-0388 N201TQJackson Zarick · Pembroke Pines, FLBuilt 1977 · S/N 24-0351 N201TRAero Nautical Electronics Inc · Starke, FLBuilt 1977 · S/N 24-0279 N201TSJacobsen Eric A · Scottsdale, AZBuilt 1977 · S/N 24-0077 N201TVHiivala Robert J · Hanover, MNBuilt 1977 · S/N 24-0332 N201TWTom Wood Aviation Inc · Fishers, INBuilt 2025 · S/N 172S13294 N201TYSingleton Kimberley P · Stuart, FLBuilt 1977 · S/N 24-0322 N201TZMayerchak Mark · Mooresville, NCBuilt 1977 · S/N 24-0324 N201UAAllard Aviation LLC · Nashua, NHBuilt 1977 · S/N 24-0361

Back to AD 81-18-04 R2