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.
N8860GBlack Spruce Aviation LLC · Hermon, MEN8861GMiller Andy D · Marana, AZN8861SJump Brian · Watsonville, CAN8861UBlanchard Donald P Jr · Napoleonville, LAN8862SBarber Theodore C Trustee · Spanish Fork, UTN8862UChase Tim W · Kearney, MON8863BMollere Michael E · Marion, TXN8863UBoatman Robert G · Great Falls, MTN8863XDupuis Logging Inc · Polson, MTN8864TRegistration Pending · Murdo, SDRegistration pendingN8865BRegistration Pending · Wentzville, MORegistration pendingN8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLN8865URegistration Pending · Parsons, KSRegistration pendingN8865XBeerman Paul L · Fort Wayne, INN88666Vincze Andras · Anchorage, AKN8866SZimmer Linda S · Hillsboro, ILN8866TTrachta Stanley J · Tucson, AZN8867BCowan Rena E · Pleasant Hill, ORN8867GDavis Robert M · Liberal, KSN8867SCooper-White Michael L · Orrtanna, PAN8867TCusimano Louis C · Montauk, NYN8867UHoffman Robert E · Blossvale, NYN8868SMeriwether John N · Prairie Village, KSN8868TKlein Ryan L · Tijeras, NMN8868UMuller Robert J · River Falls, WIN8869TDonaldson Lucas Paul · Owyhee, NVN8869XAshley Heating And Air Conditioning · Wasilla, AKN886ABWings Over Texas Holdings LLC · Denton, TXN886CPCivil Air Patrol · Maxwell Afb, ALN886CTCoast Flight Training And Management Inc · San Diego, CAN886EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN886KHLexi Air LLC · Boise, IDN88717Copp Mathew J · Cumberland, MEN8871BSing Clifford J Trustee · Idaho Falls, IDN8871GHukill Warren J · Oakland, CAN8871UWichmann William C · Owasso, OKN8871XRegistered aircraftN8872GN8872g Holdings LLC · Nashville, TNN8872SAeronautical Technical Service Inc · Collierville, TNN8873BPathfinder Aerospace LLC · Raeford, NCN8873GHarris David J · Aguila, AZN8873UOlafsen George F · Greeneville, TNN8874GEluwawalage Damayanthie · Reading, PAN8874TFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeN8875TDelahunty Brian E · Ocala, FLN8875UDunaire LLC · Mechanicsburg, PAN8876BBeryl Aviation LLC · Omaha, NEN8876XBowen Gabriel J · Salt Lake City, UTN88778Hubbard Austin L · Somerton, AZN88779Drexler Daniel L · Harrison, TN
Back to AD 79-10-14 R1