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.

N19MNShields Charles F · Gilberts, ILBuilt 1978 · S/N E-1347 N19MTDaviation Inc · Willoughby, OHBuilt 1976 · S/N E798 N19QCOn Three Angels Wings LLC · Melbourne, FLBuilt 1994 · S/N 650-0238 N19RCTequila Flights LLC · Maple Grove, MNBuilt 2016 · S/N 525-0919 N19RFLynn Air Flying Club Inc · Woodinville, WABuilt 1974 · S/N E-627 N19SASierra Aviation LLC · Hendersonville, TNBuilt 1980 · S/N E-1795 N19VChoi Mark · Allentown, PABuilt 1977 · S/N E-1107 N1BZL2 Operations LLC · Saint Paul, MNBuilt 2001 · S/N 525-0439 N1EJFlying Bishi LLC · North Miami, FLBuilt 1981 · S/N 501-0191 N1EVGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1979 · S/N E-1463 N1FMCokelet LLC · South Padre Island, TXBuilt 1997 · S/N 525-0218 N1GFFlowers George D · Panama City, FLBuilt 1982 · S/N LJ1031 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N1JWRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1982 · S/N 200 N1KTEkfj LLC · Waco, TXBuilt 1978 · S/N 230 N1LTWhite River Holdings LLC · Southaven, MSS/N BB-1824 N1LXDix Justin T · South Boston, VABuilt 1973 · S/N E-419 N1MARegistered aircraftS/N LA-3 N1MFWise Christopher J · Plano, TXS/N TH-835 N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731 N1NPNebraska Public Power District · Columbus, NES/N BB1834 N1PTWarner Aviation Properties LLC · Austin, TXBuilt 1987 · S/N FA131 N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701 N1SCState Of South Carolina · West Columbia, SCBuilt 2018 · S/N FL-1130 N1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNBuilt 2001 · S/N BB-1782 N1TRTrinity River Authority Of Texas · Arlington, TXBuilt 2013 · S/N FL-876 N1UCBas Part Sales LLC · Greeley, COS/N LW-140 N1UMUniversity Of Mississippi · University, MSBuilt 2000 · S/N 560-0543 N1VACommmonwealth Of Virginia · Richmond, VABuilt 2007 · S/N FL-549 N1VGE D Santos & Associates LLC Trustee · Wilmington, DES/N 121 N1VZKilian Michael S · Morrow, OHBuilt 1979 · S/N E-1491 N1WVState Of West Virginia · Charleston, WVBuilt 2007 · S/N FL-527 N1YMSupreme Aeronautics LLC · Haymarket, VAS/N D-1145 N1ZPConcord Flying Club Inc · Lafayette, CAFirst renewal noticeBuilt 1971 · S/N E-262 N2000Global Avionics LLC · Downey, CAS/N 56 N2000X4thd LLC · Midland, TXBuilt 1994 · S/N 560-0249 N20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 20800727 N2007UBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 20800725 N200AARad Runner LLC · Newton, NCBuilt 2019 · S/N 208B5501 N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200DAGambill Aviation LLC · Shreveport, LABuilt 1982 · S/N BB-1095 N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223 N200EARegistered aircraftBuilt 1990 · S/N BB-1368 N200FMSapphire Air II LLC · Camp Hill, PABuilt 2002 · S/N BB-1794 N200GPWesley Partners II LLC · Mount Vernon, TXBuilt 1994 · S/N BB1496 N200GSNavajo Nation · Window Rock, AZFirst renewal noticeS/N BB--1214 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200HDCooper Container Corp · Maynardville, TNBuilt 1981 · S/N BB-987

Back to AD 2006-16-18 R1