Skip to content

Registered aircraft · 17,027

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

N724LCDixon Jody S · Chancellor, ALBuilt 1966 · S/N 17254599 N724MCSutton Aircraft Salvage LLC · Palmer, AKBuilt 1970 · S/N 15072198 N724TJPellow James A · Dixie, WAS/N 17254147 N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550 N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551 N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952 N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552 N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953 N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553 N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554 N7254SNickels Robert D · Fayetteville, TNBuilt 1967 · S/N 15067954 N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555 N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593 N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557 N7257SFidalgo Flyers LLC · Anacortes, WABuilt 1967 · S/N 15067957 N7258SBusiness As Usual LLC · Spartanburg, SCBuilt 1967 · S/N 15067958 N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559 N7259SSchafer Louis L · Murfreesboro, TNBuilt 1967 · S/N 15067959 N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821 N725LCReeves Jerry H · Whitesburg, GABuilt 1964 · S/N 17251919 N725RBBatesole William D Trustee · Walpole, NHBuilt 1968 · S/N 15068309 N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254 N725VPTeam Negrich LLC · Osteen, FLBuilt 1971 · S/N U20601664 N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961 N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561 N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562 N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963 N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563 N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564 N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566 N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967 N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969 N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569 N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378 N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970 N7271SWalker Kevin · Stillwater, OKBuilt 1967 · S/N 15067971 N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678 N7272SRegistered aircraftBuilt 1967 · S/N 15067972 N7273SFerguson Jeffrey Woods · San Antonio, TXBuilt 1967 · S/N 15067973 N7274GFlyit LLC · Washougal, WABuilt 1973 · S/N 15074632 N7276SMorgan Michael · Wichita, KSBuilt 1967 · S/N 15067976 N7277SMarkland Benjamin Harrison · Lehigh Acres, FLBuilt 1967 · S/N 15067977 N7279GMartin Rick · Rindge, NHBuilt 1973 · S/N 15074633 N7279SLee Peter Joohak · Irvine, CABuilt 1967 · S/N 15067979 N727BSHorvath Andrew J · Winnsboro, SCBuilt 1966 · S/N 15064667 N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086 N727DRRoss Trucking LLC · Goldendale, WAS/N U206-0556 N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912 N727HMPatterson Casey Paul · Kinston, ALS/N 15066715 N727KDReich Brad Roy · Rohnert Park, CAS/N 17254281

Back to AD 72-03-03 R3