Skip to content

Registered aircraft · 4,469

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:94-20-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2') 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:94-20-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  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:94-20-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
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.

N8602QMarker Richard A · Healdsburg, CABuilt 1964 · S/N D-7633 N8603QHolland Jeffrey R · New Canaan, CTBuilt 1964 · S/N D-7634 N8604MLemrick Landon · Colton, ORS/N D-7229 N8604QPearson John P · Pueblo, COBuilt 1964 · S/N D-7635 N8609MHodde & Hodde Land Surveying Inc · Brenham, TXBuilt 1963 · S/N D-7236 N860TBrashier Gregery A · Decatur, TXBuilt 1964 · S/N D-7715 N8610MFawaz Brandon · Etna, CABuilt 1963 · S/N D-7237 N8610QPetersen Mark W · Poplar Grove, ILBuilt 1964 · S/N D-7623 N8611QMiller Mark A · Saint Cloud, FLS/N D-7636 N8612QStockton Ethan · Santa Rosa, CABuilt 1964 · S/N D-7638 N8615MBabb Christopher B · Key West, FLFirst renewal noticeBuilt 1963 · S/N D-7239 N861THersman Scott · Ada, MIBuilt 1964 · S/N D-7507 N8620MDoctors Building Inc · Rancho Santa Fe, CABuilt 1963 · S/N D-7289 N8621QGrossman Kenneth Randell · Merced, CABuilt 1964 · S/N D-7645 N8623QS&B Aviation LLC · Incline Village, NVBuilt 1964 · S/N D-7648 N8625MAuto & Bike Shop Inc · Douglas, WYBuilt 1963 · S/N D-7298 N8626MFlaugher Gerald E · Beloit, WIS/N D-7242 N862TNovember 862 Tango Inc · Wilmington, DES/N D-7524 N8632MMatheny Roger P · Humble, TXBuilt 1963 · S/N D-7245 N8633MFranklin Leonard R · Fresno, TXBuilt 1963 · S/N D-7335 N8636MBassue Jawanza · Savannah, GABuilt 1963 · S/N D-7246 N8636QJv Aviation LLC · Lynden, WABuilt 1964 · S/N D-7658 N8637MScarcella Joseph A · Running Springs, CABuilt 1963 · S/N D-7247 N8638MWill Matthew · Duncansville, PABuilt 1963 · S/N D-7249 N8639MCourtney John T · Woodbridge, CTFirst renewal noticeBuilt 1963 · S/N D-7265 N863STesterman George M Md · Kingsport, TNBuilt 1969 · S/N D-8922 N8642MRhodes Stephen L · Hayti, MOBuilt 1963 · S/N D-7251 N8643QFirebird Aero LLC · Phoenix, AZBuilt 1964 · S/N D-7660 N8644MShevchuk Walter Bohdan · Kennett Square, PABuilt 1963 · S/N D-7250 N8648MHeinol Chip · Choctaw, OKBuilt 1963 · S/N D-7252 N8650MMcanall Lewis D IV · Severna Park, MDBuilt 1963 · S/N D-7253 N8654QSpitler Cynthia D · Maryville, TNBuilt 1964 · S/N D-7667 N8657QSchmidt Jack R · Chagrin Falls, OHBuilt 1964 · S/N D-7738 N8658MLoach James A · Omaha, NEBuilt 1963 · S/N D-7259 N8658QHarris Austin K · Enid, OKBuilt 1964 · S/N D-7673 N8661MRoth Richard D · Riverside, CABuilt 1964 · S/N D-7280 N8662QGrant Aviation LLC · Cheyenne, WYFirst renewal noticeBuilt 1964 · S/N D-7672 N8665MAppraisal Services Inc · Walters, OKBuilt 1963 · S/N D-7264 N8665QMojo Aerospace LLC · Wilmington, DEBuilt 1964 · S/N D-7676 N8666VFriedman Michael S · Chantilly, VAFirst renewal noticeBuilt 1965 · S/N D-7832 N8667QNerstrom James S · Libertyville, ILBuilt 1964 · S/N D-7679 N8668QFrequent Flyers LLC · Kalispell, MTS/N D-7682 N8669MMayes David K · Lake Ozark, MOBuilt 1963 · S/N D-7269 N8672MN8672m LLC · Newaygo, MIBuilt 1963 · S/N D-7266 N8674QHalasi Kun David L · Suffield, CTBuilt 1964 · S/N D-7683 N8677MRegistered aircraftBuilt 1963 · S/N D-7272 N8677QLittle Lady Inc · Wilmington, DEBuilt 1964 · S/N D-7684 N8678QProffitt Perry Vaughn · Roanoke, TXBuilt 1964 · S/N D-7681 N8679QEagle Flight Services LLC · Lake Oswego, ORS/N D-7687 N867SSixty Seven Sierra LLC · Wilmington, DEBuilt 1969 · S/N D-8957

Back to AD 94-20-04 R2