Skip to content

Registered aircraft · 20,683

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.

N6394EMilco Airways Inc · River Hills, WIBuilt 1978 · S/N 17272014 N6394VRice Aviation · Maddock, NDBuilt 1980 · S/N 172RG0656 N63958Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275501 N6395DBirks Jeffrey R · Nokesville, VABuilt 1979 · S/N 17272781 N6395EStott David L · Wasilla, AKBuilt 1959 · S/N 46495 N6396DOc Flight Lessons LLC · Costa Mesa, CABuilt 1979 · S/N 17272782 N6397DGlacier Cascade LLC · Vashon, WABuilt 1979 · S/N 17272783 N6397VSale Reported · Tucson, AZSale reportedBuilt 1980 · S/N 172RG0659 N6398EMetter John R · Litchfield, OHBuilt 1959 · S/N 46498 N6399EMountain House LLC · Clear Lake, IABuilt 1959 · S/N 46499 N6399VBrim Janie J · Auburn, WAS/N 172RG0661 N639CTCoast Flight Training & Management Inc · San Diego, CABuilt 2008 · S/N 172S10780 N639EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2014 · S/N 172S11465 N639SPSpengler Raymond Francis Jr · Longview, TXBuilt 1998 · S/N 172S8047 N63AMSierra Yankee Victor LLC · Austin, TXBuilt 1980 · S/N 17273981 N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616 N63JAWings Over Texas Holdings LLC · Denton, TXBuilt 2007 · S/N 172S10484 N63JDD'Angelo Joseph P · Callicoon Center, NYBuilt 1979 · S/N 17272940 N63KGCleveland Gary W · Independence, ORBuilt 1962 · S/N 17250000 N63LUChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280591 N63SASky View Aviation LLC · Lenoir, NCBuilt 1973 · S/N 17261610 N63SVTextron Aviation Inc · Wichita, KSS/N 172S13630 N63UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12090 N64001Alpha One Aviation LLC · Corona, NYBuilt 1975 · S/N 17264949 N64007Baugh Tommye R · Star City, ARBuilt 1975 · S/N 17264955 N6400BHowes Frank E · Macomb, MIBuilt 1956 · S/N 29600 N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662 N64012Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275505 N64014Maynor Robert B · Mansfield, LABuilt 1975 · S/N 17264961 N64016Ponderosa Aviators LLC · Baker, MTBuilt 1975 · S/N 17264963 N64017Pilots Today Inc · Berlin, MDBuilt 1975 · S/N 17264964 N6401EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46501 N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663 N64020Bend Aircraft Mechanics LLC · Bend, ORBuilt 1975 · S/N 17264966 N64023Rawson Aviation LLC · Collinsville, OKBuilt 1975 · S/N 17264969 N6402EWichman Scott A · Lewistown, MTS/N 46502 N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664 N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507 N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980 N6403EGultch Dale R · Brookfield, WIBuilt 1959 · S/N 46503 N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665 N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509 N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981 N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983 N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984 N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986 N64053Collins Thomas A · Orleans, MABuilt 1975 · S/N 17264990 N64056Angel Aviation Inc · Peoria, AZBuilt 1981 · S/N 17275512 N6405ERiggs Bradley A · Emporia, KSBuilt 1959 · S/N 46505 N64061Stark Glenn M · Nampa, IDBuilt 1975 · S/N 17264994

Back to AD 90-06-03 R1