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.

N660TAReinhardt Anthony C · Duchesne, UTBuilt 1970 · S/N 17259612 N66104Rhb Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S9781 N6610AAccurso Jacob · Siletz, ORBuilt 1956 · S/N 28710 N66111Cutlass 661 LLC · Orange Park, FLBuilt 1983 · S/N 17275967 N6611DMoralli Joseph · Chico, CABuilt 1979 · S/N 17272898 N6612AMazac Kennith M · River Falls, WIBuilt 1956 · S/N 28712 N6612RCourtney David P · Reedsport, ORBuilt 1979 · S/N 172RG0214 N6612VEverman Terry Jay · Vassar, MIBuilt 1980 · S/N 172RG0781 N6613H6613 H Ltd · Wilmington, DEBuilt 1975 · S/N 17265510 N6614AHanks Mitchell L · Carthage, ILS/N 28714 N6614VThomas Anna D · Kiana, AKS/N 172RG0782 N6615DCivil Air Patrol Inc · Montgomery, ALBuilt 1979 · S/N 17272902 N66168C P Aviation · Santa Paula, CABuilt 1983 · S/N 17275974 N6616DMjng Investment Group LLC · Melbourne, FLBuilt 1979 · S/N 17272903 N6616HBurke Anthony · Poughkeepsie, NYBuilt 1975 · S/N 17265511 N66174Pea-Wayman Flight LLC · Daytona Beach, FLS/N 17275975 N6617ELinstad Daniel Elmer · Canby, ORBuilt 1978 · S/N 17272045 N6617HNorth Franklin County Flying Club · North Lawrence, NYBuilt 1975 · S/N 17265512 N6617JJeffries Holdings LLC · Bargersville, INBuilt 1980 · S/N 17273900 N66189Skynick Enterprises Inc · Tarzana, CABuilt 1983 · S/N 17275976 N6618DStein Air LLC · New Ringgold, PABuilt 1979 · S/N 17272905 N6618VLang Gerald K · Baker, MTBuilt 1980 · S/N 172RG0783 N6619ATest Jeffrey T · Port Charlotte, FLBuilt 1956 · S/N 28719 N6619DBannwart Justin S · North Liberty, INBuilt 1979 · S/N 17272906 N661EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12544 N6620AAviation Services Of Tn Inc · Sparta, TNS/N 28720 N6620DPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 17272907 N6620RWhite Richard C · Tracy, CABuilt 1979 · S/N 172RG0217 N6620VHall Steven R · Cambridge, MABuilt 1980 · S/N 172RG0784 N66213Global Adventures N66213 LLC · Hollywood, FLBuilt 1983 · S/N 17275980 N66215Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275982 N6621DCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17272908 N6622DArq Aviation LLC · Wilmington, NCBuilt 1979 · S/N 17272909 N66230East Hill Flying Club Inc · Ithaca, NYBuilt 1983 · S/N 17275985 N6623APardo Lawrence A · Tucson, AZBuilt 1956 · S/N 28723 N6623ZMage Aircraft Leasing LLC · San Antonio, TXBuilt 1980 · S/N 172RG0240 N6624GBob Hoover Academy · Salinas, CABuilt 1979 · S/N 17273611 N6624HSakata Lissa C · Falls Church, VAS/N 17265515 N6626AKrystofiak Steven · Scottsdale, AZS/N 28726 N6627AMcgowan Dan J · Springville, CABuilt 1956 · S/N 28727 N6628AJohnson Steve D · Oklahoma City, OKFirst renewal noticeS/N 28728 N662EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12548 N662HRRaymond Thomas D · Somerset, TXS/N 28725 N662SPCessna N662sp LLC · Duluth, GABuilt 1998 · S/N 172S8066 N6631AUnternaehrer Robert U Trustee · Brunswick, MOBuilt 1956 · S/N 28731 N6632A3 Fly-N LLC · Carlisle, KYBuilt 1956 · S/N 28732 N6633AKolp Mark H · Andrews, TXFirst renewal noticeBuilt 1956 · S/N 28733 N6634AKallabis Harry · Camino, CABuilt 1956 · S/N 28734 N6635ALewis John · Abbyville, KSBuilt 1956 · S/N 28735 N6637ASmedley Hank W · Lake Havasu City, AZBuilt 1956 · S/N 28737

Back to AD 90-06-03 R1