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.

N80382Sorce Sal · Clark, NJBuilt 1976 · S/N 17266563 N80389J F Aviation Inc · Joliet, ILBuilt 1976 · S/N 17266565 N80396Osprey Holding Company LLC · Foley, ALBuilt 1976 · S/N 17266569 N803BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1979 · S/N 17272258 N803CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13361 N803HPP & W Investments Inc · Wilmington, DEBuilt 1982 · S/N 17275609 N803KSKansas State University · Salina, KSBuilt 2025 · S/N 172S13389 N803SPDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 172S8108 N8040XMj Coop LLC · Sylva, NCBuilt 1961 · S/N 17248540 N80414Garn Darrell L · Palmetto, GABuilt 1976 · S/N 17266576 N80419Korona Lawrence K · West Paterson, NJBuilt 1976 · S/N 17266578 N80421Kuder Kyp E · Rogers, NDBuilt 1976 · S/N 17266580 N80425Fellows Roy H · Augusta, KSBuilt 1976 · S/N 17266582 N8042FFlying Hawks Inc · Palmyra, WIBuilt 1975 · S/N 17264378 N80436N80436 LLC · Columbia, MSBuilt 1976 · S/N 17266585 N80439Oklahoma State University · Stillwater, OKBuilt 1976 · S/N 17266586 N8043XStrandberg Kevin L · Pennock, MNBuilt 1961 · S/N 17248543 N80440Rockey John · Jupiter, FLBuilt 1976 · S/N 17266587 N80442Washburne Seth P · Dallas, TXBuilt 1976 · S/N 17266588 N8044BAshley Ken E · Maiden, NCBuilt 1957 · S/N 29844 N8044LOverton Larry D · Hermiston, ORS/N 17256244 N80454Tadao LLC · Tucson, AZBuilt 1976 · S/N 17266593 N80456Barash Geva S · Ashland, MABuilt 1976 · S/N 17266595 N80458Kolpack Glenn H · Sonora, CABuilt 1976 · S/N 17266597 N8045LAmonett Rodney · Abilene, TXBuilt 1967 · S/N 17256245 N80469Hetherly Bryce D · Clintondale, NYS/N 17266603 N8046BAnderson Charles D · Fairbanks, AKBuilt 1957 · S/N 29846 N80470Coddiwomple LLC · Newberg, ORBuilt 1976 · S/N 17266604 N80471Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 17266605 N80472Simons George Trustee · Bouse, AZBuilt 1976 · S/N 17266606 N80475Texas Southern University · Houston, TXS/N 17266608 N80476Sky Roamers LLC · Columbus, NEBuilt 1976 · S/N 17266609 N8047BGuidry Janice C · Mechanicsville, VABuilt 1957 · S/N 29847 N8047XFitzgerald Jeff D · Smithfield, UTBuilt 1961 · S/N 17248547 N80483Harrell Matthew J · Grand Haven, MIBuilt 1976 · S/N 17266611 N80484Mor Aviation 172m LLC · Gaithersburg, MDBuilt 1976 · S/N 17266612 N80486Romoser Carey E · Simpsonville, SCBuilt 1976 · S/N 17266613 N80487Williams Fredrick Glen · Auburn, ALS/N 17266614 N80489P & K Aviation LLC · Neshkoro, WIBuilt 1976 · S/N 17266615 N8048BHohman Brent A · Larchwood, IAS/N 29848 N8048LFour Dudes And A Plane LLC · Whitehouse, OHS/N 17256248 N80490American Patrols Inc · Midland, TXS/N 17266616 N80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1976 · S/N 17266617 N80495Space Coast Aero LLC · Melbourne, FLBuilt 1976 · S/N 17266619 N80496Bickel Gregory A · Mckinleyville, CABuilt 1976 · S/N 17266620 N80497Ducksrus LLC · Indianapolis, INBuilt 1976 · S/N 17266621 N8049LPrewitt Murray L · Lake Jackson, TXS/N 17256249 N804BD G Leasing LLC · Houston, TXBuilt 1976 · S/N 17266584 N804BLFlores Omar Javier · New Braunfels, TXBuilt 1979 · S/N 17273041 N804KSKansas State University · Salina, KSBuilt 2025 · S/N 172S13391

Back to AD 90-06-03 R1