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.

N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561 N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686 N6510JSabin Michael J · Virginia Beach, VABuilt 1968 · S/N 28-4946 N6510LPurpose Flight Inc · Wilmington, DES/N AA5-0610 N6510TLenkersdorfer John D · Burley, IDS/N MB-350 N6511GBuerk James R · Smethport, PABuilt 1979 · S/N 17273603 N6511JCalhoun John R · Baton Rouge, LABuilt 1968 · S/N 28-4948 N6511TAgricola Joseph D · Brooksville, FLBuilt 1968 · S/N MB-354 N6511VSc Skywalker Aviation LLC · West Sacramento, CABuilt 1980 · S/N 172RG0741 N6511WWinkler Frank · Joplin, MOS/N 28-20589 N6512DCajun Wings LLC · Bourg, LABuilt 1979 · S/N 17272836 N6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSBuilt 1975 · S/N 17265471 N6512JDion Nelson · Cromwell, CTBuilt 1968 · S/N 28-4949 N6512KLoomis Aviation LLC · Columbus, OHBuilt 1980 · S/N 17274206 N6512UWilliams Larry M · Midland, NCBuilt 1962 · S/N 2266 N6512WBirrer Urs P · Huntington Beach, CABuilt 1965 · S/N 28-20590 N6513CZorn Tony P · Lyons, GAS/N 43-2653 N6513DGhia Flying Venture LLC · Scottsdale, AZBuilt 1979 · S/N 17272837 N6513JAlexander Sam L · Fair Play, MOBuilt 1968 · S/N 28-4950 N6513TReilly Michael G · Somerset, NJBuilt 1968 · S/N MB-355 N6513UKendall Keven S · Logan, UTBuilt 1962 · S/N 2267 N6513WBuss Dillon W · Pryor, OKBuilt 1965 · S/N 28-20591 N6514JJuggernautaviation LLC · Lewes, DEBuilt 1980 · S/N 17273880 N6514RParker Scott L · Galatia, ILBuilt 1974 · S/N MB-711 N6514WDickey Jacob L · Sandy, UTBuilt 1964 · S/N 28-20592 N6515South Dakota Aviation Hall Of Fame · Spearfish, SDBuilt 1968 · S/N HCB-1 N6515UFuller Spencer A · Lake Balboa, CABuilt 1962 · S/N 2298 N6515WFrank Eric C · Frankfort, INBuilt 1964 · S/N 28-20593 N6516JTeresurv Corp · Port Saint Lucie, FLBuilt 1968 · S/N 28-4953 N6516WWalker Clint H · Tyler, TXBuilt 1965 · S/N 28-20594 N6517DSlaboszewski Donald W Jr · Joliet, ILS/N 17272839 N6517JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28-4954 N6517UNova Accounting LLC · Herndon, VABuilt 1962 · S/N 2300 N65180Mccraw Bryan · Telephone, TXBuilt 1982 · S/N 17275702 N6518UWhetzel Peter W · Mathias, WVS/N 2301 N6518WWedmore Catherine A · Wellington, FLBuilt 1965 · S/N 28-21265 N65191Bampton Dennis · Portage Des Sioux, MOBuilt 1982 · S/N 17275705 N65192Tactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 1982 · S/N 17275706 N65195Sciortino Warren A III · Crested Butte, COBuilt 1966 · S/N R1720021 N65197Aviator Education LLC · Greeley, COBuilt 1972 · S/N 17275707 N6519JDms Defense LLC · Annapolis, MDBuilt 1980 · S/N 17273882 N6519RC & C Aeroventures LLC · Carson City, NVBuilt 1974 · S/N M-1542 N6519TVeverka Merle G · Frederick, COBuilt 1968 · S/N MB-356 N6519USherr Steven · Mandan, NDBuilt 1962 · S/N 2302 N6519WFalcon Aircraft Services Inc · Rockford, ILBuilt 1964 · S/N 28-20598 N651DMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 1325-2002 N651ECEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700633 N651FLGillam Charlene · Akron, OHBuilt 1971 · S/N 28-7125563 N651FTSt Louis Flight Training LLC · Cahokia, ILBuilt 1974 · S/N 28-7415369 N651TSGoodfellow David · Sutherland, VAS/N 1138

Back to AD 79-10-03 R2