Skip to content

Registered aircraft · 85,612

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-21-21-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-21-21-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-21-21-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-21-21-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-21-21-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-21-21-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.

N2843CPacific Coast Air Museum · Santa Rosa, CAFirst renewal noticeS/N 26386 N2843DHicks Adam B · Louisville, KYBuilt 1979 · S/N 28-7911202 N2843GPopop Corp · Portland, ORBuilt 1979 · S/N 32-7940152 N2843MCar Store Inc · Honolulu, HIBuilt 1979 · S/N 32-7940154 N2843RDrandike Aviation LLC · Scottsdale, AZBuilt 1967 · S/N 18258443 N2843UFlite Five Inc · Kiowa, KSBuilt 1963 · S/N 17250443 N2843WJ & L Equipment Sales & Rental LLC · Andersonville, TNBuilt 1973 · S/N D-9496 N2843YHarper Fred S · Springerville, AZBuilt 1962 · S/N 18253843 N2844ASmith Jon K · Adairville, KYBuilt 1953 · S/N 30044 N2844DMichigan Aeronautics Commission · Lansing, MIBuilt 1994 · S/N TH-1726 N2844FN2844f LLC 0421 · Valentine, NEBuilt 1966 · S/N 18256944 N2844ML C C West LLC · Freehold, NJBuilt 1977 · S/N 28R-7837102 N2844QReigle Aviation · Palmyra, PABuilt 1971 · S/N 17259844 N2844RBower Robert W · Scottsdale, AZBuilt 1969 · S/N 28R-35306 N2844WPerformance Aircraft C LLC · Litchfield Park, AZBuilt 1973 · S/N TC-1576 N2844YChildress Hugh W · Ozona, TXBuilt 1962 · S/N 18253844 N2845ASchwartzkopf Gregory · Saint Johns, FLS/N 34-7970279 N2845COsterhout Joshua C · Prineville, ORS/N 26388 N2845FRoss Pauline · Aspen, COBuilt 1979 · S/N 28-7921062 N2845LShenk Ronald W · Palmetto, GABuilt 1967 · S/N 17256045 N2845RCarlson Kevin J · Dunedin, FLS/N 18258445 N2845YParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916471 N2846AUp And Up Aviation LLC · Magnolia, TXBuilt 1979 · S/N 28-7916472 N2846CBranstner August M · Taft, CABuilt 1954 · S/N 26389 N2846FA-Z Aviation LLC · Bay City, MIS/N 18256946 N2846GSteel Aviation LLC · Valdosta, GABuilt 1979 · S/N 28-7990489 N2846NCrew Sourcing Inc · Wilmington, DES/N 28-7990490 N2846QStafford Richard J · Bayport, NYBuilt 1971 · S/N 17259846 N2846RHaller Richard W · Cypress, TXBuilt 1979 · S/N 28-7990491 N2846SBell Stephen R · Carleton, MIBuilt 1979 · S/N 28-7990492 N2846TEdjs Holdings LLC · Gladewater, TXBuilt 1972 · S/N 28-7225251 N2846VRegistration Pending · Shawnee, OKRegistration pendingS/N D-251 N2846WJohnson Daniel P · Williamsburg, IABuilt 1973 · S/N D-9497 N2846YDasher Richard Allan · Keystone Heights, FLS/N 28R-7918171 N2847AKozacek Carter A · Duluth, MNBuilt 1953 · S/N 30047 N2847JMoses Henry A · Uvalde, TXBuilt 2002 · S/N 3257288 N2847LGervase Russell · Farmington, NMBuilt 1967 · S/N 17256047 N2847QDobbelaere Craig M · Oakwood, OHBuilt 1972 · S/N 17259847 N2847RCashman Jeremiah P · Bozeman, MTBuilt 1967 · S/N 18258447 N2847UFlow Building Solutions LLC · Cartersville, GABuilt 1979 · S/N 28R-7931221 N2847XTurner Wayne S · Parkland, FLS/N 28R-7931223 N2847YLott William R · Douglas, GABuilt 1979 · S/N 28-7911204 N28482Cecchi Jeanne · Oroville, CABuilt 1979 · S/N 34-7970211 N2848ALitzen Guide Service Inc · Kenai, AKBuilt 1953 · S/N 30048 N2848CBenedict Michael T · Anchorage, AKBuilt 1954 · S/N 26391 N2848DCastro David D Trustee · Edmond, OKBuilt 1979 · S/N 28-7911205 N2848FA5 Enterprises LLC · Dyersburg, TNBuilt 1979 · S/N 28-7921063 N2848KNeuwirth Gerald F Trustee · Lawton, OKBuilt 1979 · S/N 18053095 N2848MPumarol Rafael · Homestead, FLBuilt 1977 · S/N 28R-7837103 N2848QFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259848

Back to AD 98-21-21 R1