Registered aircraft · 572

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-03-03') 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-03-03') 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-03-03')
    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-03-03')
  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-03-03')
  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-03-03')
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.

N100PCSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N 20700467 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995 N109RSUnited States Department Of Interior · Boise, IDS/N U20606002 N10DCHbk LLC · Lynden, WAS/N U206-05366 N10FLRandall P Roumillat · Dallas, TXS/N 21062892 N10HMAggst LLC · Shingle Springs, CABuilt 1978 · S/N 21062908 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N115EL182 Flight Corp · Bronx, NYBuilt 1984 · S/N U20606814 N115RPN115rp LLC · Midland, TXBuilt 1977 · S/N 21061944 N117HLZosel Paul J · Bellingham, WABuilt 1976 · S/N 21061649 N11TCShiver James B Jr · Stanley, NMBuilt 1977 · S/N 21062230 N1215MBieber Dale E · Coralville, IABuilt 1977 · S/N 21061924 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N1237MJ&C Walker Aviation LLC · Henderson, TXBuilt 1977 · S/N 21061927 N123DMJacquin Philip Fink · New York, NYS/N 21062663 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 N125BMBaron Transporation Services LLC · Destrehan, LABuilt 1978 · S/N 21062926 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N1301LFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700641 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987 N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374 N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948 N15DACamborne USA LLC · Collierville, TNS/N 21061765 N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780 N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378 N181PKPacific Mission Aviation · Hagatna, GUS/N U20606158 N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298 N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668 N200QRPdq Flight Inc · Garden City, NYS/N U20606092 N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478 N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268 N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288 N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833

Back to AD 79-03-03