Registered aircraft · 286

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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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.

N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N213PHPyro Shows Equipment LLC · La Follette, TNBuilt 1979 · S/N BB-486 N214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CABuilt 1975 · S/N BC-02 N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621 N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739 N21DELocke-Lane Aviation LLC · Statesville, NCBuilt 1976 · S/N BB-117 N21DZBravo Hotel LLC · Lewes, DEBuilt 1977 · S/N BC-32 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N220TTShannair LLC · Saint Louis, MOS/N BB-462 N222KCU S Army - Owner · New Century, KSBuilt 1979 · S/N BC-68 N222LAGrb Logistics LLC · Grapevine, TXBuilt 1978 · S/N BB-409 N23STGreensky Aviation LLC · Mountain Home, ARBuilt 1978 · S/N BB-375 N250TMAbd Equipment LLC · Aledo, TXS/N BB822 N259GCotton Tail Transportation LLC · Singer Island, FLBuilt 1975 · S/N BB-62 N269LSSky King LLC · West Fargo, NDBuilt 1981 · S/N BB-799 N269MLAtlantic Wings LLC · New Bern, NCBuilt 1980 · S/N BB-760 N280RATechnology Service Corp · Arlington, VABuilt 1975 · S/N BB-53 N282LSJh Strain & Sons Inc · Tye, TXBuilt 1975 · S/N BB82 N284KMidsouth Air LLC · Lewes, DEBuilt 1979 · S/N BB-608 N28VUPhysicians Air Transport LLC · Hot Springs, ARBuilt 1980 · S/N BB-743 N291PANorthrop Grumman Systems Corp · El Segundo, CABuilt 1977 · S/N BB-291 N299RBKing Air Partners LLC · Howe, OKBuilt 1977 · S/N BB-296 N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319 N301PTDenaina Leasing Agency LLC · Anchorage, AKBuilt 1983 · S/N BP-028 82-23780 N301WYOrion Air Holdings LLC · Cheyenne, WYS/N BB-476 N303CJLand Of Indiana Inc · Bedford, INBuilt 1979 · S/N BB-596 N307DMBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N BB-332 N30SETradewinds 12/21 Inc · Denison, TXBuilt 1977 · S/N BB313 N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461 N316GCMarc Aircraft Holding LLC · Soldotna, AKBuilt 1978 · S/N BB-430 N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465 N321FDynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BC-70 N321PDynamic Avlease Inc · Bridgewater, VABuilt 1980 · S/N GR-10 N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396 N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553 N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335 N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548 N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865 N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456 N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816 N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514 N34UPCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N BC-006 N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741 N372JBUltra Property Acquisitions LLC · Edinburg, TXBuilt 1980 · S/N BB-719 N378ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-14 N378SFTrigg David D · Houston, TXBuilt 1978 · S/N BB-378 N379ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-15 N380ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-26 N381ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-35

Back to AD 98-20-38 R1