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.

N73671Registered aircraftBuilt 1976 · S/N 17267605 N7367AMatlock Dianne J · East Lansing, MIBuilt 1956 · S/N 29467 N7367EGregg Flying Service Inc · Durango, COS/N 17272096 N7367FDuffys Aircraft Sales And Leasing Inc · Neillsville, WIBuilt 1979 · S/N 17273256 N7367THadorn Daniel J · Solon, OHBuilt 1960 · S/N 46967 N73686Falcon Aviation Inc · Farmington Hills, MIS/N 17267612 N7368FW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 17273257 N7368JDylan Branch LLC · Tomball, TXS/N 17273912 N7369AFlying Five Inc · Fort Wayne, INS/N 29469 N736SCGolf Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13437 N73702Shiles Darrel J · Baltimore, MDBuilt 1976 · S/N 17267615 N73707Leading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N 17267620 N7370ASunrise Aero Inc · Ocala, FLBuilt 1956 · S/N 29470 N7370TVadakin Jeffrey M · Dover, DEBuilt 1959 · S/N 46970 N73719Purdue Aviation LLC · West Lafayette, INBuilt 1976 · S/N 17267624 N7371AArth Richard · Newcomerstown, OHBuilt 1956 · S/N 29471 N73726Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267630 N73728Crowe Robert B · Del Valle, TXBuilt 1976 · S/N 17267632 N73732Midway Capital Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267634 N73734Daro Norman E · Cody, WYBuilt 1976 · S/N 17267636 N73735Martineau Aircraft Inc · Butte, MTBuilt 1976 · S/N 17267637 N7373ABaker Thaddeus J · Elk, WAS/N 29473 N73744Fca Flight Center Inc · Fitchburg, MABuilt 1976 · S/N 17267643 N7374DBig E LLC · Lemoore, CABuilt 1979 · S/N 17272918 N7374EWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1978 · S/N 17272098 N73753Stick And Rudder Club Inc · Waukegan, ILBuilt 1976 · S/N 17267652 N73754Weninger Mark J · Maize, KSBuilt 1976 · S/N 17267653 N73755Lima 001 LLC · Muscatine, IABuilt 1976 · S/N 17267654 N7375GAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1970 · S/N 17259075 N7375TMclean Robert M · Baltimore, MDBuilt 1959 · S/N 46975 N73761Spring City Aviation Inc · Waukesha, WIBuilt 1976 · S/N 17267658 N73764White David W · Woodland, WAS/N 17267661 N73768Flighttime Inc · Wiscasset, MEBuilt 1976 · S/N 17267664 N73769Canino Enterprises Inc · Miami, FLBuilt 1976 · S/N 17267665 N7376TClee Jacob M · Chickamauga, GABuilt 1959 · S/N 46976 N73776Seebold Jdustin K · Mifflinburg, PABuilt 1976 · S/N 17267670 N7377ARfk Aerospace LLC · Clayton, NCS/N 29477 N7377TRock Nh Services LLC · Alpine, TXS/N 46977 N73784Dsr Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17267676 N73785Sierra Sky Aviation LLC · Whitefish, MTBuilt 1976 · S/N 17267677 N73786Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267678 N73787Pegasus Flying Club LLC · Mccordsville, INS/N 17267679 N73790Jimenez Carlos A · Davie, FLBuilt 1976 · S/N 17267682 N73798Lowry Steve · Sun River, MTBuilt 1976 · S/N 17267688 N73799Sojak Therin F · Harlingen, TXBuilt 1976 · S/N 17267689 N7379ANguyen Tuong · Henderson, NVBuilt 1956 · S/N 29479 N7379TPaulino Junior · Poughkeepsie, NYBuilt 1959 · S/N 46979 N737AAHogan Thomas A · Fairfield, OHBuilt 1977 · S/N 17269258 N737ABBellingham Aviation Services LLC · Bellingham, WAS/N 17269259 N737ACU56fliers LLC · Idaho Falls, IDBuilt 1977 · S/N 17269260

Back to AD 90-06-03 R1