Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N6414JEight Three Quebec LLC · Orange, CABuilt 1968 · S/N 28-4831 N6414RSommer Kelly L II · Galena, AKFirst renewal noticeBuilt 1966 · S/N 28-21593 N6414WOttos Aviation LLC · Kenosha, WIBuilt 1964 · S/N 28-20483 N6415JFalcon Air Co · Marina Del Rey, CABuilt 1968 · S/N 28-4832 N6415WMullins Tom H · W Alexandria, OHBuilt 1964 · S/N 28-20484 N6416JGallant Kenneth R · Beach Haven, NJBuilt 1968 · S/N 28-4833 N6416RNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 28-21595 N6417RBogey Aviation LLC · Piqua, OHS/N 28-21596 N6419JMathis Charles D · Carrollton, GABuilt 1968 · S/N 28-4836 N6420JPomerenke Tyler J · Fairmont, MNBuilt 1968 · S/N 28-4837 N6421JShoemaker Kent L · Renfrew, PABuilt 1968 · S/N 28-4839 N6421WTyde Arthur F III · Los Angeles, CAS/N 28-20491 N6422JSuncoast Aviators LLC · Odessa, FLBuilt 1968 · S/N 28-4840 N6422RYang Chi · Lafayette, COBuilt 1966 · S/N 28-21601 N6422WDomler Michael R · Gilroy, CABuilt 1964 · S/N 28-20492 N6423RBerkner Charles P · Milbank, SDBuilt 1966 · S/N 28-21602 N6424WCsapos Larry G · Ovid, MIBuilt 1964 · S/N 28-20494 N6425JPetrich Aviation LLC · Jacksonville, FLBuilt 1968 · S/N 28-4843 N6426JMunz Dennis F · Prairie Du Chien, WIBuilt 1968 · S/N 28-4844 N6427RNortheast Texas Aviation LLC · Chandler, TXBuilt 1966 · S/N 28-21607 N6428JPhillips Roger Dale II · Westfield, NCBuilt 1968 · S/N 28-4846 N6428WGeraghty John T · Long Beach, CABuilt 1964 · S/N 28-20498 N6429WFarquharson Mark · Hampton, VABuilt 1964 · S/N 28-20499 N6431RCarothers Paul W · Russellville, ARBuilt 1966 · S/N 28-21611 N6432JPeri Joshua E · Orting, WABuilt 1968 · S/N 28-4850 N6432RBreitbarth Brian · Canby, ORS/N 28-21613 N6432WStoltzman Keith W · Amboy, MNBuilt 1964 · S/N 28-20502 N6433RGary R Kasper Motor Sales · Vassar, MIBuilt 1966 · S/N 28-21614 N6433WLipinski Glen E · Chandler, AZBuilt 1964 · S/N 28-20503 N6434WBlack Scorpion Nv LLC · Elko, NVBuilt 1964 · S/N 28-20504 N6435JRegistration Pending · Pocahontas, IARegistration pendingBuilt 1968 · S/N 28-4853 N6435RSpears Travis L · North Augusta, SCBuilt 1966 · S/N 28-21616 N6437JHolt Dalin · Gig Harbor, WABuilt 1968 · S/N 28-4854 N6437RMoyer Aviation Inc · Ulysses, KSBuilt 1966 · S/N 28-21618 N643FLGoudy Steven A · Wheatland, WYS/N 28-7125551 N643MTLaurel Fork Aviation LLC · Charlottesville, VABuilt 1969 · S/N 28-5646 N643TPMcconwell Edward A Sr · Mission, KSBuilt 1971 · S/N 28-7125176 N6440JGo Vertical Aviation LLC · Russellville, ALBuilt 1968 · S/N 28-4858 N6440RAir George LLC · Oblong, ILBuilt 1966 · S/N 28-21622 N6440WMckenney Robert N · Schertz, TXBuilt 1964 · S/N 28-20512 N6441JAnsell Nathan D · Mukwonago, WIBuilt 1968 · S/N 28-4859 N6442JDeberardinis Timothy P · Logandale, NVBuilt 1968 · S/N 28-4860 N6442RAmmozon LLC · Gilbert, AZS/N 28-21624 N6443JMcfarland Kenneth E · Kansas City, MOS/N 28-4861 N6443RTangen Christopher M · Pequot Lakes, MNBuilt 1966 · S/N 28-21625 N6444RSchool Board Of Nassau County Fl · Fernandina Beach, FLBuilt 1966 · S/N 28-21627 N6445RElmore Charles E · Flowery Branch, GABuilt 1966 · S/N 28-21628 N6446RChapin Lee · Newburgh, INFirst renewal noticeBuilt 1966 · S/N 28-21629 N6447JCasper Flair LLC · Wilmington, DEBuilt 1968 · S/N 28-4865 N6447RGensler Orion M · Bloomfield, MOBuilt 1966 · S/N 28-21630

Back to AD 96-10-01 R1