Skip to content

Registered aircraft · 40,396

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

N6557HRiverside Flight Academy LLC · Riverside, CABuilt 1975 · S/N 17265487 N6557JAsd LLC · Lebanon, NJBuilt 1968 · S/N 28-5003 N6557UAtalla Mark S · Woodford, VABuilt 1962 · S/N 2340 N6557WFrederick Darin L · Star, IDBuilt 1965 · S/N 28-20638 N65587Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275780 N6558JKarr Dennis R · Clyde, OHBuilt 1968 · S/N 28-5004 N6558UReed Gina D · Starkville, MSBuilt 1962 · S/N 2305 N6558WShirley Hills Aviation LLC · Macon, GAS/N 28-20639 N6559WHarrison Michael W DBA · Lewisville, IDBuilt 1965 · S/N 28-20640 N655DKSkovbjerg Jorgen · Angwin, CABuilt 1998 · S/N 377 N655RVMartin David M · Port Saint Lucie, FLBuilt 1998 · S/N 24631 N655SMcclellan George M · Salem, ORBuilt 1946 · S/N 374 N6560RBurgett William J · Juneau, AKBuilt 1974 · S/N MB-722 N6560UTeaford Kris K · Berryville, VABuilt 1962 · S/N 2342 N6560WBeaunaux John-Daniel S · Graham, WABuilt 1964 · S/N 28-20641 N6560ZPiper Aviation Museum Foundation · Lock Haven, PAS/N 25-711 N65614American Patrols Inc · Midland, TXBuilt 1982 · S/N 17275785 N6561JKyode Inc · Creswell, ORS/N 28-5012 N6561UJones Charles · Mountain Grove, MOBuilt 1962 · S/N 2343 N6561WAnderson Vance K · Eugene, ORBuilt 1965 · S/N 28-20642 N65620Condair Flyers Inc · Latham, NYBuilt 1982 · S/N 17275787 N65623Hoffman William C · Mount Pleasant, PABuilt 1982 · S/N 17275788 N65624Carver Clarence K · Lutz, FLBuilt 1982 · S/N 17275789 N65626Smith Terry G · Liberty Twp, OHBuilt 1982 · S/N 17275790 N65628Circle Nineteen Aviation LLC · Burlington, CTBuilt 1982 · S/N 17275791 N6562JSmrekar Andrew E · Edgerton, WIBuilt 1968 · S/N 28-5013 N6562RChavis Martin R · Laurel Hill, NCBuilt 1974 · S/N M-1614 N6562UTaquara LLC · Ridgewood, NYBuilt 1962 · S/N 2344 N6562VAero-Sphere Inc · Longmont, COBuilt 1980 · S/N 172RG0775 N6562WRm & Lp Ltd · Azalea, ORS/N 28-20643 N6563BFurmanski Stan · Encino, CABuilt 1958 · S/N 1233 N6563UCard Damon · Chicago, ILBuilt 1962 · S/N 2345 N65645Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1982 · S/N 17275797 N6564JL K H LLC · Boyden, IABuilt 1968 · S/N 28-5016 N6564PInfinity Aviation LLC · Piedmont, SDBuilt 1959 · S/N 24-1686 N6564UK & S Aviation LLC · Harrisburg, PABuilt 1962 · S/N 2346 N65658L A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275804 N6565JTaylor Aviation Of Seminole Ok LLC · Seminole, OKBuilt 1980 · S/N 17273891 N6565UTherriault Thomas · Avondale, AZBuilt 1962 · S/N 2347 N6565VHodges Marshall E · Orange, TXBuilt 1980 · S/N 172RG0776 N65665Tomolonius Nathan · Newington, CTBuilt 1982 · S/N 17275810 N65673Middletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1982 · S/N 17275814 N6567UDonnelly Lewis J · Warwick, NYBuilt 1962 · S/N 2349 N6568EMcnerney John P · New Haven, VTBuilt 1978 · S/N 17272038 N6568JMorring Roy S · New Hope, ALBuilt 1968 · S/N 28-5021 N6568RJofredo Corp · Zephyrhills, FLBuilt 1979 · S/N 172RG0202 N6568UHowell Larry A · Terrell, TXBuilt 1962 · S/N 2350 N65690690 LLC · Carmel, INBuilt 1982 · S/N 17275820 N65698Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275822 N6569JLegend Aviation LLC · Columbus, MSBuilt 1968 · S/N 28-5022

Back to AD 79-10-03 R2