Skip to content

Registered aircraft · 5,443

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') 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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N2833SJohanson Lawrence Gco Trustee · Mckinleyville, CAS/N 28-7916458 N2834BSager Arthur · Joseph, ORBuilt 1979 · S/N 28-7990477 N2834TCrosswire Networks & Camera Systems Inc · Tampa, FLS/N 28-7990478 N2835MWth Aviation Services LLC · Scott City, KSBuilt 1977 · S/N 28-7890271 N28360Albert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 28-7916403 N28361Propell Air LLC · Deridder, LAS/N 28-7916404 N2836GRed Rock Fly LLC · Lewes, DEBuilt 1979 · S/N 28-7916459 N2836NGreat Planes Aviation Inc · Rochester, MNBuilt 1979 · S/N 28-7916461 N28381Hanscom Aero Club · Hanscom Afb, MABuilt 1979 · S/N 28-7916408 N2838DHis Promise Aviation Service Inc · Big Spring, TXBuilt 1979 · S/N 28-7916463 N2838FGordon Brennan L · Houston, TXBuilt 1979 · S/N 28-7916464 N2839BGartman Henry L Sr · Moberly, MOBuilt 1979 · S/N 28-7990485 N283BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842419 N283BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881675 N283DXPiper Aircraft Inc · Vero Beach, FLS/N 28010107 N283HGCompas Rose 3 LLC · Corinth, TXBuilt 1995 · S/N 2842008 N283HPClarke John D Jr · Port Orange, FLBuilt 2000 · S/N 2843360 N283MKAlpe Holding LLC · Van Nuys, CAS/N 2842134 N283PAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 2844059 N283ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881615 N2840MHamby Scott D · Custer, SDBuilt 1977 · S/N 28-7890272 N2841MHaller Robert W · Austin, TXBuilt 1977 · S/N 28-7890273 N2841VSouth Jersey Aero Club Inc · Haddonfield, NJBuilt 1979 · S/N 28-8090027 N2841YShimak Joseph O · Toms River, NJBuilt 1979 · S/N 28-7990487 N28421Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843730 N2842DTwo Tangos Aviation LLC · Covington, LABuilt 1979 · S/N 28-7990488 N2844ML C C West LLC · Freehold, NJBuilt 1977 · S/N 28R-7837102 N2845YParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916471 N2846AUp And Up Aviation LLC · Magnolia, TXBuilt 1979 · S/N 28-7916472 N2846GSteel Aviation LLC · Valdosta, GABuilt 1979 · S/N 28-7990489 N2846NCrew Sourcing Inc · Wilmington, DES/N 28-7990490 N2846RHaller Richard W · Cypress, TXBuilt 1979 · S/N 28-7990491 N2846SBell Stephen R · Carleton, MIBuilt 1979 · S/N 28-7990492 N2848MPumarol Rafael · Homestead, FLBuilt 1977 · S/N 28R-7837103 N284BOpen Roads Complete Rv Service LLC · Acworth, GABuilt 2020 · S/N 2881372 N284BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881713 N284CHorizon Instruction LLC · Addison, TXBuilt 2024 · S/N 2881698 N284FCapitan Hair LLC · Lubbock, TXBuilt 2021 · S/N 2881454 N284HFour Hotel LLC · Olathe, KSBuilt 2021 · S/N 2881480 N284HGCompass Rose 4 LLC · Austin, TXBuilt 1995 · S/N 2842009 N284HPSpurlock Michael E · Appleton, WIBuilt 2000 · S/N 2843372 N284LMullys Equipment Leasing LLC · Keizer, ORBuilt 2018 · S/N 2881071 N284MKCote Natasha · Sunapee, NHFirst renewal noticeS/N 2842135 N284RMesa Aviation LLC · Mesa, AZBuilt 2018 · S/N 2881028 N284SVpf Aircraft LLC · Cave Creek, AZBuilt 2026 · S/N 28010016 N284TARegistration Pending · Augusta, KSRegistration pendingBuilt 1978 · S/N 28-7916075 N284UWest Texas Flyers Inc · Fredericksburg, TXBuilt 2017 · S/N 2843892 N284VThree Daughters Aviation LLC · Fort Worth, TXBuilt 2023 · S/N 2881668 N284WFAims Community College · Greeley, COBuilt 2025 · S/N 2881863 N2851GN2851g LLC · Lagrange, GABuilt 1979 · S/N 28-7916474

Back to AD 2016-07-21