Skip to content

Registered aircraft · 567

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:73-26-07-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3') 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:73-26-07-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
  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:73-26-07-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
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.

N426DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152824 N426MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-645 N428MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-646 N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N42AXTheia Aviation LLC · Philadelphia, PABuilt 1996 · S/N 41084 N430MAGas/Wilson Inc · Traverse City, MIS/N AC-710B N430RRAce In The Sky LLC · San Antonio, TXBuilt 1974 · S/N AT030 N431MTDucharme Paul Quinn · Lafayette, LAS/N LIV-517 N434CAHorizon Aire LLC · Colorado Springs, COBuilt 1981 · S/N 286 N439DFUsda Forest Service Fepp · Mcclellan, CABuilt 2002 · S/N 149854 N439RARyan Air Inc · Anchorage, AKBuilt 1982 · S/N 287 N43GTDon Avion LLC · Cedar Park, TXBuilt 1978 · S/N 441-0043 N440ATT & M Aircraft LLC · Monticello, ILS/N G10-104 N441ABank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 441-0094 N441ABPistol Aviation LLC · Anaconda, MTBuilt 1981 · S/N 441-0284 N441AQM & M Aircraft LLC · Mankato, MNBuilt 1981 · S/N 4410203 N441BBMountain Sand Investment LLC · Wilmington, DEBuilt 1981 · S/N 441-0217 N441BKBek Consulting LLC · Dickinson, NDBuilt 1981 · S/N 441-0215 N441CCNoem Troy · Grand Junction, COBuilt 1977 · S/N 441-0008 N441CJNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1979 · S/N 441-0117 N441CTAberdeen Flying Service · Aberdeen, SDBuilt 1978 · S/N 441-0048 N441DFUsda Forest Service Fepp · Mcclellan, CABuilt 2003 · S/N 152808 N441DNSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 441-0325 N441DSWiley Equipment Leasing LLC · Leucadia, CABuilt 1978 · S/N 441-0028 N441EClausen Aviation LLC · Norfolk, NEBuilt 1982 · S/N 441-0306 N441EBPlane Space Inc · West Palm Beach, FLBuilt 1978 · S/N 441-0049 N441EHSurdex Corp · Chesterfield, MOBuilt 1985 · S/N 441-0351 N441EMNeo Terra Aviation LLC · Setauket, NYBuilt 1980 · S/N 441-0137 N441GValhalla Aviation LLC · Sioux Center, IABuilt 1981 · S/N 441-0230 N441GAValiair Limited Company Trustee · Casper, WYBuilt 1981 · S/N 441-0234 N441GGTrans Business And Investments LLC · Colorado Springs, COBuilt 1981 · S/N 441-0269 N441HLCmc Airtrans LLC · Hermosa Beach, CABuilt 1981 · S/N 441-0202 N441HSKb Ranch Land LLC · Weatherford, TXBuilt 1983 · S/N 441-0330 N441KMKa LLC · New Paris, INBuilt 1978 · S/N 441-0044 N441KPCorrado Aviation LLC · Columbia, MOBuilt 1978 · S/N 4410062 N441LALee Aero LLC · Wichita, KSBuilt 1981 · S/N 4410210 N441LSMeander Air LLC · Warren, OHBuilt 1984 · S/N 441-0342 N441MCovington Holdings Inc · Covington, OHBuilt 1979 · S/N 441-0122 N441MECastle Crown Properties LLC · Roseburg, ORBuilt 1981 · S/N 441-0266 N441MHConquest Training Management LLC · Naples, FLBuilt 1980 · S/N 441-0163 N441MKMkt Partners LLC · Mankato, MNBuilt 1981 · S/N 441-0211 N441NDFlying Fish 441 LLC · Phoenix, AZBuilt 1979 · S/N 441-0123 N441PMJtg Enterprises LLC · Mayfield, KYBuilt 1980 · S/N 441-0124 N441PNPioneer Nursery · Visalia, CABuilt 1985 · S/N 441-0347 N441PWSophie Sullivan LLC · Hartland, MIBuilt 1981 · S/N 441-0240 N441RBruce The Flying Dog LLC · San Marcos, CABuilt 1984 · S/N 441-0343 N441SBCfc 441 LLC · Cicero, INBuilt 1982 · S/N 441-0301 N441SMEssex Transport LLC · Canton, GABuilt 1980 · S/N 4410134 N441TDColumbia Asset Trust Corp Owner Trustee · Wichita, KSBuilt 1980 · S/N 441-0170 N441TGDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 441-0200

Back to AD 73-26-07 R3