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.
N60388Mcnulty David R · Arundel, MEN6038BHaarmeyer Air LLC · Lovington, NMN6038VEdb Air Inc · Wilsonville, ORN60395American Aviation Inc · Brooksville, FLN60397Vector USA LLC · Olive Branch, MSN60398Wagoner Aviation LLC · Clovis, CAN60399Smith Foster Fritz · Bishopville, SCN6039JMccullough Charles Acie · Grand Saline, TXN6039KMejia Soto Luis I · Plainfield, CTN6039NTwin City Cloud 7 Inc · Eden Prairie, MNN603EREmbry-Riddle Aeronautical University Inc · Prescott, AZN603ETSanborn Map Co · Colorado Springs, CON603NDFm Aviation Services LLC · Arlington, VAN603TCReyes Gordon L · Houston, TXN60400Brink Dennis R DBA · Lubbock, TXN60406Chopper Aviation LLC · Cahokia Heights, ILN60407Payne Anthony G · Warrenton, VAN60408Mac Coy Clifford J · Line Lexington, PAN6040AOlaf LLC · Bellbrook, OHN6040BErickson Keith D · Carver, MNN6040CZach Air Corp · Byfield, MAN6040GPineland Holdings LLC · Gibsland, LAN6040KReyna Zachary · Windcrest, TXN60411Walters Craig S · Lake City, FLN60413Schramm Stacey · South Rockwood, MIN6041AKlosterman Aviation LLC · Celina, OHN6041BNewell Scott A · Seeley Lake, MTN6041JCandler Field Museum Inc · Griffin, GAFirst renewal noticeN6041NLj Camp LLC · Longview, TXN6041RStanley Herb · Morgan City, LAN60425Sale Reported · Lexington, KYSale reportedN60429Mccall Freddie · Brewton, ALN6042AWoods Richard C · Raeford, NCN6042BWilson Janis O · Friendswood, TXN6042JGeer Chad C · Murrieta, CAN6042NCal Aggie Flying Farmers · Davis, CAN6042RMetz Jonathan M · Corpus Christi, TXN6042ZL&G Skycatcher LLC · Bradenton, FLN60430County Of Henrico Virginia · Henrico, VAN60435Georgia Forestry Commission · Macon, GAN60439Walker Timothy M · Brockport, NYN6043AGriffin Tiffany J · Collinsville, OKN6043RDelage Enterprises · Dent, MNN60441Hawkins Richard · Tybee Island, GAN60443Diesing Daniel D · Monroe, MIN60447Marquette County Flying Club · Marquette, MIN60449Carlson Matthew S · Westminster, CON6044NB407 LLC · Seattle, WAN6044RLee Brett · Austin, TXN6045AFleischman Matthew A · Moab, UT
Back to AD 79-10-14 R1