Skip to content

Registered aircraft · 1,752

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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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.

N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111 N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145 N213SALatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1973 · S/N 28R-7435138 N2141THorizon Ventures Inc · Red Oak, IABuilt 1971 · S/N 28R-7135144 N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089 N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069 N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281 N216GCSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 28R-7135151 N21870Tezaguic-Swanson Olga I · Wichita Falls, TXBuilt 1978 · S/N 28R-7837309 N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345 N2191LAir Leasing Service Inc · Hillsborough, NJS/N 28R-7918031 N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032 N21LKDalton Versel Jr · Fort Myers, FLBuilt 1973 · S/N 28R-7335207 N2204TNgugi Samson W · El Paso, TXBuilt 1971 · S/N 28R-7135168 N2206QVandeman Jack · Norco, CABuilt 1979 · S/N 28R-7918052 N220MGCornwell Anne L · Athens, OHBuilt 1978 · S/N 28R-7837156 N2212DMichel David L · Greenville, SCBuilt 1973 · S/N 28R-7335443 N2215QMoore Verba A · Biloxi, MSBuilt 1979 · S/N 28R-7918054 N2218ZArtisan Aviation Inc · Rochester, NYBuilt 1979 · S/N 28R-7918117 N2219ZSchneider Robert E · Hacienda Heights, CABuilt 1979 · S/N 28R-7918118 N221SDKimball James R · Indian Trail, NCBuilt 1974 · S/N 28R-7535081 N2226TRegistration Pending · Tucson, AZRegistration pending, pending cancellationBuilt 1971 · S/N 28R-7135171 N222HBUniversal Aviators Academy Inc · El Monte, CABuilt 1979 · S/N 28R-7918254 N222RACaptain Rick LLC · Miami Lakes, FLBuilt 1973 · S/N 28R-7435127 N223WWSan Diego Flight Training Inc · San Diego, CABuilt 1978 · S/N 28R-7837251 N2241NBell Michael C · Sammamish, WABuilt 1979 · S/N 28R-7918043 N2242NSt Louis Flying Club Inc · Ellisville, MOBuilt 1979 · S/N 28R-7918044 N2247MCamp Randall · Duncan, SCBuilt 1977 · S/N 28R-7837073 N2247XElliott James F · Florence, ALBuilt 1979 · S/N 28R-7918094 N2248GClear Skies Aviation 1959 LLC · Boca Raton, FLS/N 28R-7918016 N2248XSecond Life Properties LLC · Salisbury, MDBuilt 1979 · S/N 28R-7918095 N2249XElwood Andrew D · Essex, CTBuilt 1979 · S/N 28R-7918096 N224HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844131 N2250XValdes Manuel · Miami Beach, FLBuilt 1979 · S/N 28R-7918097 N225PACapitol Aircraft Inc · Wilmington, DEBuilt 1976 · S/N 28R-7635443 N2263QRoss Air Chicago LLC · Chicago, ILBuilt 1977 · S/N 28R-7737030 N2266MGraves Robert E · Danville, INBuilt 1977 · S/N 28R-7837075 N2272TNedley Nathan D · Georgetown, KYBuilt 1972 · S/N 28R-7235001 N2273TDevenezia Robert P · Brentwood, TNBuilt 1971 · S/N 28R-7135175 N2274THoller James F · Stuart, FLBuilt 1971 · S/N 28R-7135176 N2279TRegistration Pending · Lakeville, MNRegistration pendingBuilt 1971 · S/N 28R-7135181 N2285QGandy John W III · Mount Vernon, TXBuilt 1977 · S/N 28R-7737032 N228NCIal Corp · Lewes, DEBuilt 1969 · S/N 28R-35652 N228TXTexas State Technical College · Waco, TXFirst renewal noticeBuilt 2007 · S/N 2844136 N2292MShymkewich Dale G · Arlington, VABuilt 1977 · S/N 28R-7837081 N2293MFines Aviation #1 LLC · Fargo, NDBuilt 1977 · S/N 28R-7837082 N2294QSouth Florida Helicopters Inc · Indiantown, FLS/N 28R-7737033 N229DRSpecialty Veterinary Services LLC · Monteverde, FLBuilt 1976 · S/N 28R-7635320 N22HABig Bend Aviation LLC · Odessa, TXBuilt 1979 · S/N 28R-7918053 N22KSWhite Brian · Forsyth, GABuilt 1972 · S/N 28R-7235019

Back to AD 81-11-02 R1