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.

N111AHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2004 · S/N 3531 N111AZ360 LLC · Carson City, NVFirst renewal noticeBuilt 2000 · S/N 28-43311 N111BE7gcbeec LLC · Boise, IDBuilt 1970 · S/N 277-70 N111BNChalasani Rajiv · Fort Worth, TXBuilt 1998 · S/N 20469 N111CGPegasus Aviation LLC · Rogersville, MOBuilt 1969 · S/N 147 N111CNNelson Craig K · Golden, COBuilt 1942 · S/N 75-5962 N111CPVelasco Ricardo Rene Jr · Cumming, GABuilt 1969 · S/N 28R-35326 N111CSMaster Wings LLC · Princeton, KYBuilt 1969 · S/N 18-8860 N111DBRaven Aviation LLC · Lewistown, MTBuilt 1953 · S/N 18-3682 N111DHHeusinkveld Karen B · San Marcos, TXBuilt 1991 · S/N 336 N111DJLee Brian A · Riverdale, GABuilt 1972 · S/N 28R-7235038 N111DQMedical Surgical Clinic West Bend Pc · Fort Scott, KSBuilt 1995 · S/N 652 N111DTInternational Air Services Inc Trustee · Carson City, NVBuilt 1960 · S/N 24-2260 N111EEPereira Alfred R Jr · Valley Springs, CABuilt 1977 · S/N 1075 N111EMMccue Inc · Florence, MTBuilt 1985 · S/N 28-8690042 N111EXNew Orleans Aviation LLC · Covington, LABuilt 1986 · S/N 17275024 N111FBMccarthy Elaine M · Indianapolis, INBuilt 1973 · S/N 28R-7335310 N111FPPhoenix Carolina LLC · Saint Petersburg, FLBuilt 1970 · S/N 28R-35818 N111FRAirward Inc · Novato, CABuilt 1972 · S/N 28-7325055 N111GPVan Haitsma Kelley · Fort Worth, TXBuilt 1981 · S/N 24-1193 N111HHarvey Mushman LLC · Kalispell, MTBuilt 2004 · S/N 70695 N111HMSciara Flying Service LLC · Eudora, ARBuilt 1978 · S/N 1055-78 N111HPFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1984 · S/N 172RG1153 N111JHBlazie Marketing Service Inc · Street, MDS/N 2549 N111KTHolt Helicopters Inc · Uvalde, TXBuilt 2001 · S/N 3273 N111LAAmmons Curtis D · Hernando, MSBuilt 1976 · S/N AA5B-0249 N111LHSuperior Aviation Gateway LLC · Tampa, FLBuilt 1977 · S/N 17269965 N111LRLo Jeffrey G · San Jose, CABuilt 2004 · S/N 001 N111LSGrant William S · Azle, TXBuilt 1995 · S/N 740-95 N111MJJohn D Chinchen Md Pa · Mountain Home, ARBuilt 1968 · S/N 680147 N111MLArcara Sebastiano · Bridgeton, NJBuilt 1977 · S/N 1 N111MVVodon Mark A · Ventura, CABuilt 2004 · S/N 21869 N111NFNakonieczny David · The Colony, TXBuilt 2024 · S/N 5148 N111NPBlackfoot Aviation LLC · Bozeman, MTS/N 28-3046 N111NRMartin Roy Keith · Ocala, FLBuilt 1998 · S/N 111001 N111PBRegistered aircraftBuilt 1997 · S/N 2705 N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929 N111PPPerritt Ricky D · Milton, FLS/N AM-3 N111PSAjeac Inc · Fairview, PABuilt 2019 · S/N SUV111 N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874 N111SA111sa LLC · Greeley, COBuilt 1972 · S/N 17260937 N111TJKrueger Steven A · Merrill, WIBuilt 2000 · S/N 001 N111TKMclendon Thomas A · Crockett, TXBuilt 1968 · S/N 17257828 N111TQEngbring Paul · Telluride, COBuilt 1993 · S/N 1243 N111UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3750 N111UYGonzales Jon · Prairieville, LABuilt 2003 · S/N 2227 N111VXParmar Jaywant Philip · San Luis Obispo, CABuilt 2003 · S/N 3FG031 N111WHamilton Steven T · Reno, NVBuilt 1945 · S/N 1420 N111WMMoore Forrest · Liberty Hill, TXBuilt 1978 · S/N 28R-7837159 N111XFBender Thomas G · Albuquerque, NMBuilt 1997 · S/N 24474

Back to AD 90-04-06 R1