AD 79-10-14 R1
Registered aircraft · 56,582
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
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.
N4952GHighland Rim Aviation LLC · Springfield, TNN4953AOlson Andrew P · Garfield, WAN4953EInland Fisheries And Wildlife · Augusta, MEN4953GMcfly LLC · Casper, WYN4953VMccreery Aviation Co Inc · Mcallen, TXN4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeN4954GKris Noone Air LLC · Wilmington, DEN4955DBerman David M · Charlotte, NCN4955YLancaster Bryant F Jr · Troutman, NCN4956DSorbi Aviation Inc · El Cajon, CAN4956NCosta Luiz A · Fort Myers, FLN4956VRegistered aircraftN4957DCummings Roy E · Fort Scott, KSN4957FBravo Hotel LLC · Lewes, DEN4957NRegistered aircraftN4957ZGuinasso Kimberly Marsh · Reno, NVN4958DHarmon Jon E · Turner, MTN4958QSnider Scott E DBA · Turner, MTN4958VFrank John M Jr · Alexandria, VAN4959CDoll House Properties Inc · Chesapeake, VAN4959DEdwards Stephen L Trustee · Wasilla, AKN4959VCutlass Cruisers Inc · Howard Lake, MNN495EMAround The Patch LLC · Memphis, TNN495EREmbry-Riddle Aeronautical University · Daytona Beach, FLN495KKatmai Air LLC · Anchorage, AKN495MCC182t LLC · Chattanooga, TNN495RAGabbard Derek L · Paint Lick, KYN495SPFlying Start Aero Services LLC · Reno, NVN495WWNational Aircraft Leasing Corp · Greenville, DEN495ZZach Brian D · Loveland, CON4960DRasmussen Scott M · Santa Cruz, CAN4960RUnited States Air Force Owner · Cannon Afb, NMN4960UHopkins Breck G · North Little Rock, ARN4961AGunson Robert S · Star, IDN4961ELafferty David W · Harrisburg, ORN4961GGardner Clifton T · Vernal, UTN4962DMcdonald Richard Reid · Rock Island, WAN4962FEvans Dick G Trustee · Riverside, CAN4962GVersteeg Martin · San Antonio, TXN4962VAircraft Partner Holdings Inc Trustee · BerlinN4963GSunwest Aviation Inc · Santa Ynez, CAN4963NHarrison Earl S · Clarksville, TNN4963UAllen Shanda · Aynor, SCN4964AThree Sisters Capital LLC · Visalia, CAN4964DGrizzly Air Service Inc · Paris, TXN4964FTeam Builders Inc · Carson City, NVN4964GCrotts Aircraft Service Inc · Dodge City, KSN4965NDowner Michael · Scottsdale, AZN4966E4966e LLC · Kalispell, MTN4966GSonger Charles W III · Tuscaloosa, AL
Back to AD 79-10-14 R1