Skip to content

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N742DKaurich Steven · O Brien, FLBuilt 1953 · S/N D-3412 N7444SBlkbrdz LLC · Grand Ledge, MIS/N D-8803 N745DWjs Business Development Consulting LLC · Gainesville, GABuilt 1951 · S/N D-3015 N745VKoritz Terence C · Ladera Ranch, CABuilt 1965 · S/N D-7953 N7461NUniversal Coatings Inc · Fresno, CABuilt 1968 · S/N D-8832 N7462NBartels Randall John · Wesley Chapel, FLBuilt 1968 · S/N D-8833 N7463NTiger Owl Properties LLC · Centennial, COBuilt 1968 · S/N D-8834 N746DDunn Jennifer D · Athol, IDBuilt 1951 · S/N D-3016 N7475NN7475n LLC · Indianapolis, INBuilt 1968 · S/N D-8837 N7476NGeorge Andrew N · Corvallis, ORBuilt 1968 · S/N D-8836 N747BPRose James M · White Hall, ARBuilt 1973 · S/N D-9440 N747TMTripodi Joseph J · Glendale, AZBuilt 1961 · S/N D-6796 N749DOliver Rodney W · Houston, AKBuilt 1951 · S/N D-3019 N749WClark Jimmy Dee · Lorenzo, TXBuilt 1955 · S/N D-4278 N74CBKendrick Paul · Atascadero, CABuilt 1974 · S/N D-9690 N74RHCirrus Management LLC · Suwanee, GABuilt 1955 · S/N D-4153 N74SKKoontz Construction Inc · Livingston, MTBuilt 1966 · S/N D-8148 N7516NDelis Balentine Jeremy W · Phoenix, AZBuilt 1968 · S/N D-8846 N7517NEagle Squadron Inc · The Villages, FLBuilt 1968 · S/N D-8845 N7518NHarper Darin M Trustee · Independence, ORBuilt 1968 · S/N D-8843 N751DSloan Parker Ryan · Pryor, OKBuilt 1951 · S/N D-3021 N7521RWatchill LLC · Traverse City, MIBuilt 1965 · S/N D-7835 N752DSpoltman James H · Oak Harbor, WABuilt 1953 · S/N D-3413 N755DN755d Llp · Sidney, MTBuilt 1951 · S/N D-3025 N755TAg Air Ltd · Harwood, NDBuilt 1972 · S/N D-9364 N755XLandis David A · Perryton, TXBuilt 1967 · S/N D-8578 N755YMathews David J · Blue Earth, MNBuilt 1961 · S/N D-6642 N756EEHoster Keith DBA · Gordon, TXS/N D-8549 N756TN756t LLC · North Royalton, OHBuilt 1972 · S/N D-9369 N757DWilcox Stacy S · Parker, COBuilt 1951 · S/N D-3027 N757ERJohnson Nathaniel D · Attalla, ALBuilt 1966 · S/N D-8139 N757HZInabnit Kevin J · Bozeman, MTBuilt 1957 · S/N D4961 N7594HVtanza LLC · Indianapolis, INBuilt 1968 · S/N D-8822 N75DJValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N D-7088 N75PRScott Jerry · Wingate, TXBuilt 1959 · S/N D-5809 N75RJones Daniel · Cypress, TXBuilt 1964 · S/N D-7730 N75SSMurdock Kent A · Roll, AZBuilt 1963 · S/N D-7140 N761LTFiddelman Joseph D · Port Orange, FLBuilt 1978 · S/N D-10187 N7624NUhuru II LLC · Phoenix, AZBuilt 1968 · S/N D-8854 N762BMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N D-5511 N762TFair Skies LLC · East Meadow, NYBuilt 1973 · S/N D-9434 N764DBonanza Partners · Sleepy Hollow, ILBuilt 1951 · S/N D-3034 N7653NPieri James A · Gallatin, TNS/N D-8858 N7660NGeorge Sterling Gardner Trustee · Elk Grove, CABuilt 1957 · S/N D-5669 N766SQualls Shannon D · Mexico, MOBuilt 1965 · S/N D-7818 N766TDecesare George D · Danville, CABuilt 1973 · S/N D-9445 N767TMJavelina Aero LLC · Sheridan, WYBuilt 1967 · S/N D-8556 N767URegistered aircraftBuilt 1968 · S/N D-8873 N7684NMccarthy Mitchell S · Stamford, CTBuilt 1968 · S/N D-8867 N768KMShafferman Edward L · Shreveport, LABuilt 1963 · S/N D-7256

Back to AD 94-20-04 R2