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.

N44MKCypress Aircraft Sales LLC · Clermont, FLS/N 501-0272 N44MQAircraft Holdings Solutions LLC Trustee · Newark, DEBuilt 1994 · S/N 6507043 N44NDGrand Air LLC · Missoula, MTBuilt 2015 · S/N FL-998 N44RFKtpt Capital Holdings LLC · Hilton Head Island, SCBuilt 1985 · S/N 650-0072 N44TEThomaston Bonanza Club Inc · Thomaston, GABuilt 1975 · S/N E-796 N44UNHawker 258359 LLC · Dover, DEBuilt 1998 · S/N 258359 N44USEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1975 · S/N BB-56 N44VSHornet Aviation LLC · Anaheim, CABuilt 2002 · S/N 525-0500 N44ZMSchnurbusch Larry · Saint Louis, MOBuilt 1978 · S/N E-1279 N4501VRegistered aircraftS/N D-1322 N4504SRegistered aircraftBuilt 1975 · S/N E-720 N4504VWiley Calvin · Summer Shade, KYBuilt 1948 · S/N D-1325 N450CKCeekay Leasing LLC · Fort Worth, TXS/N FL-464 N450CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N FL-340 N450JRNowell Borders Lp · Edinburg, TXBuilt 1975 · S/N TH-670 N450KPKalinin Partners LLC · Juneau, AKS/N 208B5882 N450MMDcbf LLC · Aledo, TXBuilt 1991 · S/N 560-0119 N450PPJ R S Sky Inc · Pound Ridge, NYBuilt 1975 · S/N 450 N450THHk Air LLC · Byron, GABuilt 1981 · S/N TH-1298 N450WSMatter Donald Chad Trustee · Friendswood, TXBuilt 1979 · S/N E-1552 N4512VDortch Steven D · La Vernia, TXBuilt 1948 · S/N D-1334 N4515SHarris Aviation LLC · Texarkana, TXBuilt 1975 · S/N E-725 N4519SBlanck Greg J · Redwood City, CABuilt 1975 · S/N E-719 N4519VCarrell Samuel R · Knoxville, TNBuilt 1948 · S/N D-1342 N451AMPalm Tree Adventures LLC · Austin, TXS/N 421C0808 N451DABrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N 5510141 N451MJRoost Leasing LLC · Sturgis, MIBuilt 1985 · S/N E-2246 N451NGOne Amigo LLC · Raleigh, NCBuilt 2022 · S/N 525-1128 N451STrevathan Max Tyler · Dyersburg, TNBuilt 1977 · S/N E1200 N451SBModleski Matthew · Noblesville, INBuilt 1978 · S/N TH-897 N4524SKnox James P · Park Rapids, MNBuilt 1975 · S/N E-727 N4525VMiller Grady F · Kingsland, TXBuilt 1948 · S/N D-1348 N4528VHagglund Carl D · Pendleton, ORBuilt 1948 · S/N D-1352 N452CWashington Derrick A · Louisville, KYBuilt 1999 · S/N E-3256 N452TWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5304 N452TBU S Special Operations Command · Macdill Afb, FLBuilt 2009 · S/N FL-623 N4533VStraight Fly LLC · West Jordan, UTS/N D-1359 N4534SMarmon Robert A · Merion Station, PABuilt 1975 · S/N E-743 N453ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36354 N453JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 1991 · S/N 560-0158 N453SAHts LLC · Hudsonville, MIBuilt 2002 · S/N E-3453 N4540Mathis Mark L · Fremont, CABuilt 1971 · S/N E-299 N4541MPerez Johnathan Daniel · Placerville, CABuilt 1978 · S/N E-1232 N45440United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33535 N4545MSimplifly Aviation LLC · Elon, NCBuilt 1978 · S/N TH-914 N4546VThwing Randy L · Las Vegas, NVFirst renewal noticeBuilt 1948 · S/N D-1373 N4547MOxly Aviation LLC · Wilmington, DEBuilt 1978 · S/N TH-915 N454ACCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 501-0015 N454DCEllis Dd King Air LLC · Midlothian, TXS/N BB-995 N454DPSkyview LLC · Wilmington, DES/N 130

Back to AD 2006-16-18 R1