Skip to content

Registered aircraft · 177

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-01-02-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-01-02-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-01-02-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-01-02-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-01-02-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-01-02-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.

N1026BBazler Jack A Trustee · Boulder, COBuilt 1956 · S/N LH-163 N103BABemidji Aviation Services Inc · Bemidji, MNBuilt 1971 · S/N LD-435 N103MPJoyce George E · Franklinville, NCS/N LF-50 N104BABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-235 N106BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N LD-409 N107WSByers Mike L · Vista, CABuilt 1959 · S/N GH-107 N110BABemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-279 N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37 N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20 N117WBHicks Jacob · Crozet, VABuilt 1960 · S/N DH-275 N120RDDecesare George D · Danville, CABuilt 1956 · S/N DH-89 N1235MRoan Christopher J · Jefferson, SDS/N DH-142 N123TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1962 · S/N DH-339 N12FHR&B Leasing And Finance LLC · Fresno, CABuilt 1956 · S/N DH-63 N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297 N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331 N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202 N134TBKbld LLC · Buchanan, MIS/N HH-126 N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68 N1421GGomez Vecslir Martin L · Redwood City, CABuilt 1962 · S/N DH-333 N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71 N144LHPaul John R · Hamilton, MTS/N RLH14 N146RAerospatiale LLC · Selah, WAS/N HH-145 N14VUBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1962 · S/N DH-326 N154LHPaul John R · Hamilton, MTS/N LH154 N154NWoods John · Eagle River, AKBuilt 1955 · S/N CH-333 N155PAllman Air LLC · Blackstone, VABuilt 1956 · S/N DH-76 N15PCollins Jeffery S · Griffin, GABuilt 1956 · S/N DH-92 N15PHBindon Phil E · Wasilla, AKBuilt 1958 · S/N RLH-20 N1600GBrown David · Bell Buckle, TNBuilt 1959 · S/N DH-211 N160LTodd Victor E · London Mills, ILBuilt 1958 · S/N DH-201 N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68 N188Gear Robert Lee III · Paradise Valley, AZS/N LC70 N1959TPhantom Phlyers LLC · Pearland, TXBuilt 1959 · S/N DH-209 N1961Buttram John R · Panama City, FLS/N DH318 N197CANighthawk Air Systems Inc · Miami, FLBuilt 1965 · S/N LD-246 N1DUPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1960 · S/N DH-262 N2038WYanagida Kazuaki · Norco, CABuilt 1973 · S/N LD-459 N207AFFlying Burros Air Trucking Co · Wilmington, DEBuilt 1955 · S/N CH-144 N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34 N212GBailey Orin A · Homedale, IDBuilt 1955 · S/N CH-331 N213DBall Frederick C · Harbor Springs, MIBuilt 1955 · S/N CH-192 N218PDMoye Robert W · Saint Augustine, FLS/N LF-48 N220DSChagrin Valley Biplanes LLC · Chagrin Falls, OHBuilt 1960 · S/N DH-271 N2240Twin Bonanza LLC · Meridian, IDBuilt 1956 · S/N DH-35 N225BWRegistered aircraftBuilt 1961 · S/N DH-325 N225TWWallitner Aviation And Restoration LLC · Port Orchard, WABuilt 1959 · S/N DH-219 N227DSL & P Air LLC · Lees Summit, MOBuilt 1957 · S/N FH-74 N234HWestphal Ronald R · Aurora, ILBuilt 1954 · S/N CH-133 N2400ZDerr Douglas N · Woodlands, TXBuilt 1957 · S/N DH-137

Back to AD 79-01-02 R2