Skip to content

Registered aircraft · 40,395

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.

N3043ZMaria A Sklar Pa DBA Sklar Law Trustee · Fort Lauderdale, FLBuilt 1959 · S/N 22-6997 N30441Gillenwater Timothy J · Glasgow, KYBuilt 1968 · S/N 17701256 N30443Songer Harvey · Beech Grove, ARBuilt 1968 · S/N 17701257 N30446Gumz Terry J · Wailuku, HIS/N 17701260 N3044USkywest Leasing Inc · St George, UTBuilt 2003 · S/N 2843572 N3044ZRoberts Marvin L · Calhoun, GABuilt 1959 · S/N 22-6998 N30450Recker Timothy J · Aurora, IABuilt 1968 · S/N 17701262 N30452Midland Aircraft Sales & Service Inc · Marshalltown, IABuilt 1978 · S/N 28-7916085 N30458Spires William B · Minden, NVBuilt 1968 · S/N 17701267 N3045AEssex Air LLC · Franklin Lakes, NJBuilt 1978 · S/N 28-7916106 N3045CPadelford Leman W DBA · Taunton, MABuilt 1978 · S/N 28-7916138 N3045ZColson Douglas J · Emmitsburg, MDBuilt 1959 · S/N 22-6999 N30463Chambers Frederick J · Lake Forest, CABuilt 1968 · S/N 17701271 N30464Cunningham Augustus Bruce · Madison, ALBuilt 1968 · S/N 17701272 N30469Saisha Jariwala LLC · Miami Springs, FLBuilt 2004 · S/N 2843589 N3046MMs Miami Properties LLC · Doral, FLS/N 28-7816331 N3046TFlying Rangers Inc · Livingston, MTBuilt 1979 · S/N 28-7990321 N3046ZSzostak Edward M · San Diego, CABuilt 1959 · S/N 22-7000 N30470Duthie John P · Nipomo, CAS/N 1542 N30474Ross Richard R · Jerseyville, ILBuilt 1968 · S/N 17701277 N30475Am Rhein Thomas R · Watsonville, CABuilt 1973 · S/N 17262791 N30477Cheha Evert S · Lake Arthur, LAS/N 17701279 N3047BOregon Aero Academy Inc · Albany, ORBuilt 1978 · S/N 44-7995113 N3047FTracey Bruce E · Nevada City, CABuilt 1978 · S/N 28-7990224 N3047ZRiffle David T · Woodinville, WABuilt 1960 · S/N 22-7001 N30480Meadowlake Airpark LLC · Lenoir City, TNS/N 17701280 N30483Yates Matthew · Estero, FLBuilt 1978 · S/N 28-7890454 N30484Jenkins Taylor · Bogart, GABuilt 1968 · S/N 17701282 N30487Keim Monty J · El Paso, ILBuilt 1968 · S/N 17701284 N3048ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1978 · S/N 17271417 N3048PMeginnes Mark A · Tucson, AZBuilt 1957 · S/N 23-959 N3048RAlbert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 44-7995242 N3048TKullair Aviation LLC · Encinitas, CABuilt 1979 · S/N 28-7990322 N3048ZPalmatier Curt A · Montrose, PABuilt 1959 · S/N 22-7002 N30493Dixon Jessee H · Elk Grove, CAS/N 17701287 N3049LPadilla Marcial Jr · Abingdon, MDBuilt 1979 · S/N 28-7916249 N3049MBradley Jason C · Hammonton, NJBuilt 1977 · S/N 28-7816333 N3049PTaildragger Aero LLC · Saint John, WABuilt 1957 · S/N 23-961 N3049QFrost Aviation Services Inc · Las Cruces, NMS/N 28-7790433 N304CVacendak William A · Palmer, AKBuilt 2000 · S/N 2113 N304DFDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1966 · S/N 78 N304RABrendle Robert E · Forest City, NCBuilt 1977 · S/N 2862 N304SFPerle Mark · Plainfield, ILS/N 216 N30500Hansen Larry A · Waverly, IABuilt 1968 · S/N 17701291 N30502James A Caufield · King City, ORBuilt 1968 · S/N 17701292 N3050EDsi Limited Liability Corp · Blue Ridge, VABuilt 1978 · S/N 17271419 N30514S&S Aircraft Inc · Bennington, VTBuilt 1974 · S/N 17264141 N3051EBellingham Aviation Services LLC · Bellingham, WABuilt 1978 · S/N 17271420 N3051NOdendaal Willem G · Blacksburg, VABuilt 1979 · S/N 28-7990286 N3051WWong Direction LLC · Lantana, TXBuilt 1981 · S/N 28-8116276

Back to AD 79-10-03 R2