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.
N684DWSun Aircraft Management LLC · Ormond Beach, FLN684MCT&B Aero LLC · Jacksonville, FLN684SSecond Wind Aviation Corp · Friday Harbor, WAN684SPCondor Aero Club Inc · Zelienople, PAN6850BJennings Donald J · Gypsum, CON6850ESchott Nicholas F · Burns, ORN6850GVoorheis Patrica D · Casa Grande, AZN6851ECharlie Lima 1 LLC · Jacksonville, FLN6851FCarr Thomas W · Grand Blanc, MIN6851R6851r LLC · Greeley, CON6852AFabian Ryan S · Vancouver, WAN6852HSetter Jory · Midvale, UTN6852RJensen Sid R · Idaho Falls, IDN6853HJohnson Seth W · North Pole, AKN6854ADulin Thad L · Midland, TXN6854ERowe Cecil D · Knoxville, TNN6854GUniverse LLC · Prospect, KYN6854HN6854h LLC · Opa Locka, FLN6855ACowley Dale Thomas Trustee · Sandusky, MIN6855RD & N Holdings Inc · Boca Raton, FLN6856EHigh Plains Agronomics Inc · Milliken, CON6856MWoodall Larry Douglas · Auburn, WAN6857GDuran Alexander · Holbrook, NYN6857HNew Mexico Flying Eagle Inc · Tucson, AZN6857MRegistration Pending · Lenoir City, TNRegistration pendingN6857RRegistered aircraftN6858ACorrigan Flying Club · Manitowoc, WIN6858EMalara Steven · Frankfort, NYN6858HPrairie Skies Aviation LLC · Hutchinson, KSN6858XHoang Andrew Q · Seal Beach, CAN6859AClark Brenton J · Fairfield, IAFirst renewal noticeN6859EAndersen Henrik T · Golden, CON6859HRoeper Gary Lee · Linden, MIN6859MRegistration Pending · Woodruff, SCRegistration pendingN6859RRomeo Airmotive LLC · Stockton, CAN6859XWilkerson Bradley W · Caldwell, IDN685ACMullerhill Inc · Hillsboro Beach, FLN685BBHeavenly Flight LLC · Cumming, GAN685DWUpper Valley Flying Club Inc · White Riv Jct, VTN685GTEatmb Air Inc Trustee · Wilmington, DEN685JMBallard Aviation · Waynesville, MON685LACorr Joshua · Santa Paula, CAN685RADenkat Plane Shadow LLC · Buckeye, AZN685SSecond Wind Aviation Corp · Friday Harbor, WAN685SPDirty Side Down Aviation LLC · Georgetown, TXN685VAlpha Golf Flyers Inc · Wilmington, DEN6860HUniversity Of Michigan Flyers · Ann Arbor, MIN6861EBeckerman George F · Mount Carmel, ILN6861HViking Systems Inc · Naples, FLN6861MEwing Aviation LLC · Ellisville, MS
Back to AD 79-10-14 R1