Skip to content

Registered aircraft · 56,578

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-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798 N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030 N19312Morley Thomas O · Riverside, CABuilt 1973 · S/N 15074329 N19313Stout Walt · Willow Beach, AZBuilt 1973 · S/N 15074330 N19315Adams Jacob M · Port Orchard, WAS/N 15074331 N1931HMountain Air Aviation LLC · Fruit Heights, UTBuilt 2006 · S/N 172S10128 N1931QKlaes Sheldon T · Fairbanks, AKBuilt 1977 · S/N 18503504 N1931VRegistered aircraftBuilt 1974 · S/N 17263799 N1931XRuffner Ryon Garrett · Argyle, TXBuilt 1965 · S/N 18256031 N1931ZCrandell Cyrus · Rockville, INBuilt 1962 · S/N 15059731 N19320Hynes Timothy M · Pepperell, MABuilt 1973 · S/N 15074335 N19323Novinski Gerald W · Jacksonville, FLBuilt 1973 · S/N 15074338 N19325Leon River Aerial Services LLC · Dublin, TXBuilt 1973 · S/N 15074339 N19326Sagen Josh H · Kalispell, MTBuilt 1973 · S/N 15074340 N19328Amesbury Robert S · Davis, CABuilt 1973 · S/N 15074342 N19329Harvey James · Arlington, TNBuilt 1973 · S/N 15074343 N1932CSchone Aviation LLC · Albert Lea, MNBuilt 1953 · S/N 26077 N1932QHogan James C DBA · Cameron Park, CABuilt 1973 · S/N 177RG0332 N1932UFryer Charles Trustee · Glendale, AZBuilt 1969 · S/N 18501623 N19333Northwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 15074346 N19334Beiswinger Matthew · Republic, MOBuilt 1973 · S/N 15074347 N19336Ozark Aviation Services LLC · Wasola, MOBuilt 1973 · S/N 15074349 N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023 N1933MShepherd Matthew R · Bloomington, INBuilt 1976 · S/N 18264487 N1933XHall Michael D · Athens, ALBuilt 1965 · S/N 18256033 N1933ZIsherwood Robert N · Carnesville, GABuilt 1962 · S/N 15059733 N19342Wojciechowski Calvin · Sonoma, CABuilt 1973 · S/N 15074352 N19343Goheen Gordon C · Battle Ground, WABuilt 1973 · S/N 15074353 N19345Dynan Erik J · Whitefield, NHBuilt 1973 · S/N 15074355 N19346Acevedo Adriel · San Antonio, TXBuilt 1973 · S/N 15074356 N1934COber John · Candor, NYBuilt 1953 · S/N 26079 N1934GAero-Tech Services Inc · Lititz, PABuilt 2006 · S/N 172S10129 N1934MKornetzke Jeffrey A · Lake Mills, WIBuilt 1976 · S/N 18264488 N1934XMarshall Michael R · Collierville, TNBuilt 1965 · S/N 18256034 N1934ZKlausen Mark R · Overland Park, KSBuilt 1962 · S/N 15059734 N19351Place Joseph E · Springville, NYBuilt 1973 · S/N 15074359 N19355Airco Interational LLC · Arlington, WABuilt 1973 · S/N 15074360 N19358Browning Helen · Peoria, ILBuilt 1973 · S/N 15074362 N1935ZHubbert Leroy N · Mecosta, MIS/N 15059735 N19364Ja Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 15074366 N19367Boyer Timothy J · York, PAS/N 15074369 N19369Aci Aviation LLC · Costa Mesa, CABuilt 2006 · S/N 172S10130 N1936CLalomia Vincent · Montclair, NJBuilt 1953 · S/N 26081 N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026 N1936MScott George M · Reno, NVS/N 18264489 N1936XNelson William T · Benton, KYBuilt 1965 · S/N 18256036 N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181 N19374Wilson Aviation Consulting LLC · Willis, TXS/N 15074374 N19377Caffroy Daniel R · Anchorage, AKBuilt 1973 · S/N 15074376 N1937CJensen Deleigh S · Dell Rapids, SDBuilt 1953 · S/N 26082

Back to AD 79-10-14 R1