Skip to content

Registered aircraft · 40,401

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.

N12893Weiss Lyle D · Faith, SDBuilt 1973 · S/N 17262348 N12897Foothill Aircraft Sales & Service Inc · Upland, CABuilt 1973 · S/N 17262352 N12898Nova Ivan · Hackensack, NJS/N 17262353 N12899Lyon Kimberly J · Layton, UTBuilt 1973 · S/N 17262354 N128AKMcgill Alvin R · Joliet, MTS/N 133 N128ALWilson Timothy S · Newbury Park, CABuilt 2004 · S/N 25006 N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218 N128AVMacair Aviation LLC · Xenia, OHBuilt 1984 · S/N 28-8516007 N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128DPGherebi Belaid A · San Diego, CAS/N 28-7125293 N128EPPalicki Anthony J · Huntsville, ALBuilt 1985 · S/N 172-76482 N128HRDerenick Aviation LLC · Aguadilla, PRS/N 17262679 N128JDHopwood Roy Neal · Rio Rancho, NMBuilt 1999 · S/N 24632 N128KTClaus Logan D · Chitna, AKBuilt 1975 · S/N 18-7509089 N128LFLewis Michael D · Jenks, OKBuilt 2004 · S/N 81507 N128MAFca Flight Center Inc · Fitchburg, MABuilt 1975 · S/N 17263941 N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171 N128PTaddeo Brent J · Cumming, GABuilt 1979 · S/N M-2220 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N128RSGwizair LLC · Lewes, DEBuilt 1999 · S/N 22078 N128SMHafford Jay T · Stevenson, WAS/N 1162-79 N128VUTiger 2 Flying Club LLC · Geneseo, ILBuilt 1991 · S/N 10067 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327 N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986 N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382 N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294CJel Imaging Services LLC · Rochester, NYBuilt 1977 · S/N 17702698 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398 N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399 N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400

Back to AD 79-10-03 R2