Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N201QCDigital Outdoor Adertising LLC · Reno, NVS/N 24-0305 N201QEWaters Michael C · Social Circle, GABuilt 1977 · S/N 24-0343 N201QHPodd Bradley Stephen · Wilmington, NCBuilt 1977 · S/N 24-0348 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 N201TYSingleton Kimberley P · Stuart, FLBuilt 1977 · S/N 24-0322

Back to AD 90-04-06 R1