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.
N91066King D Kenyon · Chatham, NHN9106ARegistered aircraftN9106BRegistered aircraftN9106HLapenna Mark A · Madison, INN9106MWeekley Marlin · Metamora, ILN9106USpafford Luke · Pontiac, ILN9106XCollinsville Design LLC · Newington, CTN91078T Or M LLC · Brentwood, TNN9107BGrace Community Church · Fremont, OHN9107HChm Aviation LLC · Wilmington, DEN9107MBurns Robert L · Bremen, GAN9107UAnderson Christopher · Janesville, WIN91084Cropair Flying Service Inc · Cody, WYN9108AHendrickson Larry L · Chester, MTN9108GLeder John A · Marble, NCN9108MHorinek Dave L · Goodland, KSN9108URegistration Pending · Studio City, CARegistration pendingN9108XDighans Michael J · Peerless, MTN9109ADra Classic Aircraft LLC · Gravette, ARN9109GVess David G · Gaffney, SCN9109HJunior Coal Contracting Inc · Philipsburg, PAN9109UBrotherson Brian C · Independence, KYN9109XUplift Aviation LLC · Dover, DEN910AAWest Michigan Aviation Academy · Grand Rapids, MIN910CPCivil Air Patrol Inc · Maxwell Afb, ALN910HPState Of Ohio · Columbus, OHN910LFNby Productions · Bristow, VAN910PFCertified Aviation LLC · Morristown, NJN910SEBates Jonathan R · Chatsworth, CAN910TWMultnomah County Sheriffs Office · Portland, ORN9110ASmith Sidney R · Rllng Hls Est, CAN9110HSierra Aero LLC · Truckee, CAN9110XCoffman Ryan S · Marysville, WAN91116Adventure Airways Inc · Homer, AKN9111MSierra Air LLC · Willow, AKN9111UKingdom Air Corps Inc · Sutton, AKN91121Central Illinois Aviators Inc · Galesburg, ILN9112BFosgate Helen Hines · Bogart, GAN9112GPomeroy Vincent Lee · Anchorage, AKN9112MJlck LLC · Jordan, NYN9112UOstrander William P · Millerton, PAN9112XSorenson Chad · Soldotna, AKN9113BBrown David L · Spring City, TNN9113MGospel Ministries International Inc · Collegedale, TNN9114AHayes Sean M · Kodiak, AKN9114HRohwer Michael G Trustee · Tucson, AZN9114UMarek John M · Tucson, AZN9114XDk1 Aviation LLC · Fayetteville, NCN9114ZLarson Richard W · Sioux Falls, SDN91152Dt Pralle Enterprise Inc · Hampton, IA
Back to AD 79-10-14 R1