Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N500FEBeech Transportation Inc · Eden Prairie, MNBuilt 1986 · S/N BB-1212 N500FRInterstellar Air LLC · Gainesville, FLBuilt 1992 · S/N 650-0208 N500FZDb N941jp LLC · Largo, FLBuilt 1989 · S/N 560-0018 N500GEStevenson Anesthesia Associates Pc · Wolfforth, TXBuilt 1977 · S/N E-1130 N500GGSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1990 · S/N E-2564 N500HGEm Aviation Ka B200 LLC · Atlanta, GAS/N BB-1954 N500LDJ & H Investment Corp Inc · Columbia, MOBuilt 1979 · S/N TH-1008 N500LPMeri Acquisitions LLC · Kilgore, TXS/N BB-1141 N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323 N500PBLegendary Air LLC · Destin, FLBuilt 2006 · S/N FL-514 N500SBKostelic Tanner · Alpena, MIBuilt 1973 · S/N E-482 N500SEPjh Consulting LLC · Reno, NVBuilt 1994 · S/N FL125 N500TLSententia LLC · Highland Park, ILBuilt 1999 · S/N TH-1890 N500TUAlpha Jets USA Inc · Clarksville, TXBuilt 1962 · S/N 500A-1259-83 N500UJMmi Air LLC · Bakersfield, CABuilt 1990 · S/N 560-0062 N500VLAir Walker LLC · Virginia Beach, VAS/N FL-383 N500WJKiesau Insurance Services LLC · Lenoir City, TNS/N 501-0275 N500XPHawker 800xp LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258455 N500ZBFregata Systems LLC · Saint Louis, MOBuilt 1985 · S/N S550-0023 N501Stallion Aircraft LLC · Miami, FLBuilt 1977 · S/N 501-0011 N501ALandrock Real Estate Inc · Reedley, CABuilt 1977 · S/N 501-0051 N501ABRegistration Pending · Richmond, VARegistration pendingBuilt 1978 · S/N 501-0082 N501ADCrockagator Adventures LLC · Sabina, OHS/N 501-0093 N501AJFreiford LLC · Pasco, WAS/N 501-0059 N501AKDl Fly LLC · Santa Maria, CABuilt 2009 · S/N 525-0689 N501ATEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1977 · S/N 501-0017 N501BBWno Trust Services LLC Trustee · Wilmington, DES/N 501-0087 N501BZN501bz LLC · Boca Raton, FLBuilt 1987 · S/N S550-0144 N501CBSnoe Gary A · Somerville, TXBuilt 1978 · S/N 5010281 N501CDCroman Corp · White City, ORBuilt 1978 · S/N 501-0066 N501CFApex Tower Group LLC · Spring, TXBuilt 1979 · S/N 501-0128 N501CJOstrich Boot LLC · Little Rock, ARBuilt 1999 · S/N 525-0355 N501CPP And D Partnership II LLC · Oro Valley, AZS/N 501-0034 N501DDDk Air LLC · Brookings, ORBuilt 1977 · S/N 501-0035 N501DPBraden Health LLC · Greensboro, NCBuilt 1980 · S/N 501-0162 N501DUWaterside Holdings LLC · Knoxville, TNBuilt 1980 · S/N LA-82 N501EBPrecision Holdings LLC · Kimberly, IDBuilt 1978 · S/N BB-422 N501EXFloatsix Leasing LLC · Wilmington, DEBuilt 2013 · S/N 208B5010 N501GRBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1977 · S/N 501-0006 N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565 N501HSLewis Garry L · Livingston, LABuilt 1979 · S/N 501-0096 N501JDUniversal Air Service Ltd · Wilmington, DEBuilt 1979 · S/N 501-0129 N501JGChallenger Aircraft Charters LLC · Newport Beach, CABuilt 1996 · S/N 560-0344 N501JJKelsay Roger B · Hillsboro, ORS/N 501-0269 N501JMBohn Martin · Wichita Falls, TXS/N 501-0226 N501JVJetvue Texas LLC · Richardson, TXBuilt 1982 · S/N 373 N501KWFly Buy LLC · Kalispell, MTBuilt 1979 · S/N 5010092 N501MBGarood LLC · Redmond, WAS/N 501-0122 N501MCCharlie Chase Aviation LLC · Findlay, OHBuilt 1981 · S/N 501-0204 N501MFGreyshore Aviation LLC · Mystic, CTS/N 501-0244

Back to AD 2006-16-18 R1