Skip to content

Registered aircraft · 20,687

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N7LPFirth Leonard F · Navasota, TXBuilt 1975 · S/N 17265467 N7XYHewett Nancy A · Tacoma, WAS/N 17261254 N7YZAeronautical Enterprises LLC · Woodinville, WABuilt 1970 · S/N 17258814 N8000BRoberts David C · Sidney, IABuilt 1957 · S/N 29800 N8000XRush Adelaide K · Anchorage, AKBuilt 1961 · S/N 17248500 N8001BRobinson Stephen A · London, KYBuilt 1957 · S/N 29801 N8001LHoupt David · Clinton, OHBuilt 1967 · S/N 17256201 N8003BLeopardi David E · Salt Lake City, UTBuilt 1957 · S/N 29803 N8003LCrump Shawn C · Gonzales, LABuilt 1967 · S/N 17256203 N8003XSwenson Donald C · Stanchfield, MNBuilt 1961 · S/N 17248503 N8004XSchriever Rebecca M · Lees Summit, MOS/N 17248504 N8006LGmdg LLC · Shreveport, LABuilt 1967 · S/N 17256206 N80079Ramos Anthony K · Fresno, CABuilt 1975 · S/N 17266356 N80087Kazmer Gary W · North Windham, CTBuilt 1975 · S/N 17266360 N80088Wolgat Alexander · White Lake, MIS/N 17266361 N8008BNeill James H · Keller, TXBuilt 1957 · S/N 29808 N80090Cloud Hoppers II LLC · Chicago, ILBuilt 1975 · S/N 17266363 N80092Bronco Flying Service · Coldwater, MIBuilt 1975 · S/N 17266364 N80094Hartshorn Michael P · Danville, ILBuilt 1976 · S/N 17266366 N80095Ivy James E · Alba, TXBuilt 1975 · S/N 17266367 N80097Yates Gregory A · Murrayville, ILBuilt 1975 · S/N 17266368 N8009BTaber Floyd K · Osceola, IABuilt 1957 · S/N 29809 N800FCFargo Curt J · Vacaville, CAS/N 17256726 N800MDPark Whitney Foutz · Boulder, COBuilt 1977 · S/N 17269123 N80102Transonic LLC · Wilmington, DES/N 17266369 N80105Heilmann Charles E · Millwood, WVBuilt 1975 · S/N 17266371 N80106American Patrols Inc · Midland, TXBuilt 1975 · S/N 17266372 N8010LLegion Flying Club Inc · Springfield, MABuilt 1967 · S/N 17256210 N80112Lind Enterprises LLC · Manistee, MIBuilt 1975 · S/N 17266377 N80116Laingkids LLC · Lewes, DEBuilt 1975 · S/N 17266380 N80117Valley Fliers Flying Club · Auburn, WABuilt 1975 · S/N 17266381 N80118Skylens LLC · Hammond, LABuilt 1975 · S/N 17266382 N80119Wellman David H · Eugene, ORBuilt 1975 · S/N 17266383 N8011LLaska Lonny J · Tonawanda, NYBuilt 1967 · S/N 17256211 N80121Sky Gypsies LLC · Lansdale, PABuilt 1975 · S/N 17266384 N80123Fremont Aviation Inc · Fremont, NEBuilt 1975 · S/N 17266385 N80127J C Dalco Inc · Westminster, CABuilt 1975 · S/N 17266388 N80128Gonzalez William I · Babylon, NYBuilt 1975 · S/N 17266389 N80129Potter Raymond C · Torrey, UTBuilt 1975 · S/N 17266390 N8012XSingh Joga · Auburn, WABuilt 1961 · S/N 17248512 N80130Harrison W Henry · Philadelphia, PABuilt 1975 · S/N 17266391 N80131Riverside Pilots Inc · Riverside, CABuilt 1975 · S/N 17266392 N80135Adventure North Flying Service Inc · Aitkin, MNBuilt 1975 · S/N 17266395 N80137Walla Walla University · College Place, WABuilt 1975 · S/N 17266397 N80138Candace A Larned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 172RG0507 N8013LCarroll Connie S · Clyde, TXBuilt 1967 · S/N 17256213 N80149Cielos Serenos LLC · Tucson, AZBuilt 1975 · S/N 17266403 N8014BHeinrich George F Jr · Hastings, MNBuilt 1957 · S/N 29814 N8014EHutton Steve · Saint Helens, ORFirst renewal noticeBuilt 1978 · S/N 17272117 N80154Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17266405

Back to AD 90-06-03 R1