Skip to content

Registered aircraft · 3,961

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

N37376Trans Western Leasing LLC · Sheridan, WYBuilt 1977 · S/N 340A0374 N373JCVon Allman Chris D · Dos Palos, CABuilt 1962 · S/N 310G0137 N37404Bear Giant LLC · Eden Prairie, MNBuilt 1977 · S/N 421C0339 N37417Registered aircraftS/N 421C0344 N37424Flight Development LLC · Wichita, KSS/N 421C0658 N3744GValiair Limited Co Trustee · Casper, WYBuilt 1977 · S/N 310R0909 N37475N37475 Management LLC · Las Vegas, NVBuilt 1977 · S/N 421C0412 N37478Ghareeb Enterprises Inc · Charleston, WVS/N 421C0415 N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818 N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105 N3752CMiller Robert G · Clear Lake, IAS/N 414-0819 N37543Construction Solutions & Consulting LLC · Sedalia, MOS/N 414A0002 N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839 N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226 N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468 N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584 N377CEMetal Mistress Aviation LLC · Meadowview, VABuilt 1976 · S/N 310R0631 N377JMSanchez Joshua A · Bosque, NMBuilt 1976 · S/N 421C0221 N377JS270 Aviation LLC · Elizabethtown, KYBuilt 1979 · S/N 340A0672 N378KAga Aviation LLC · Lewes, DES/N 421C0499 N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803 N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914 N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616 N37FSLuxury Transportation LLC · Talladega, ALS/N 414A0830 N37GMCraft Engineering Associates Inc · Hampton, VABuilt 1979 · S/N 340A0684 N37JKSsr LLC · Incline Village, NVS/N 421B0934 N37MBresciani Martin · Guaynabo, PRS/N 421B0805 N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823 N37UJet Set Aircraft Inc · Van Nuys, CABuilt 1977 · S/N 414A0010 N3809XVoracek Michael G · Richardson, TXBuilt 1966 · S/N 310K-0209 N3812XJets And Props Corp · Reno, NVS/N 310K0212 N3813GOne Three Golf LLC · Cleghorn, IABuilt 1977 · S/N 310R0916 N3813XRegistered aircraftAssigned, pending cancellationS/N 310K0213 N3817XPeterson Randall J · Lake Havasu City, AZBuilt 1966 · S/N 310K0217 N3818XAcme Racing LLC · Overland Park, KSBuilt 1966 · S/N 310K0218 N3819XBoerne Flight Options LLC · Boerne, TXBuilt 1966 · S/N 310K0219 N3820XDwyhalo David W · Moorpark, CABuilt 1966 · S/N 310K0220 N3823XRegistration Pending · Logan, UTRegistration pendingBuilt 1966 · S/N 310K0223 N3828GChoice Aviation LLC · Hamilton, MTS/N 310R0923 N382BWWd Aviation Group Inc · Atlanta, GAS/N 421C0711 N382CRSkyport Aviation LLC · Oxford, MIBuilt 1982 · S/N T30300096 N382MCShiver James B · Stanley, NMS/N 421B0452 N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671 N3838XHolzman Douglas S · Hood River, ORBuilt 1966 · S/N 310K0238 N3839XMigliaccio Vicki Trustee · Idabel, OKBuilt 1966 · S/N 310K0239 N3841XJ W Faherty Inc · Apple Valley, CABuilt 1966 · S/N 310K0241 N3844CMansfield Heliflight Inc · Milton, VTS/N 310R1238 N3845XHaas James D · Frisco, TXBuilt 1966 · S/N 310K0245 N384AMHaggard Haley G · Springer, OKS/N 421B0304 N3850GN3850g LLC · Stamford, CTBuilt 1976 · S/N 340A0208

Back to AD 87-21-02 R1