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.
N5927ASamaritans Purse · Boone, NCN5927BEmerson Christopher D · Mount Pleasant, ARN5927RRodrigues Robert R · Cordova, AKN59286Staley Ronald L · Lebanon, ORN5928AToribio LLC · San Antonio, TXN5928BSteinhausen Darrell · Torrington, WYN5928EGace Flying Club Inc · Ronkonkoma, NYN5928FKerr Daniel · Bakersfield, CAN5928JParsons Royson A · Atascadero, CAN59292Cloud Busters LLC · Goodrich, MIN59294Cornucopia Investment Group LLC · South Jordan, UTN59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKN5929BRegistered aircraftN5929EAnderson Raymond O · Bismarck, NDN5929TFlight School Of Gwinnett Inc · Lawrenceville, GAN592CPCivil Air Patrol · Maxwell Afb, ALN592HPAeroquest LLC · Olive Branch, MSN592JSStraut James M · Upper Saddle River, NJN592KBCopper River Airmotive LLC · Copper Center, AKN592PCFlanagan Geri M · Bandon, ORN5930AUthe Wendy G · Wellsville, MON5930FCable Strong Aircraft Holdings LLC · Tyler, TXN5930RDownwind Corp · Brush Prairie, WAN5931GOconnor Mary B · Anchorage, AKN5931TFreitas Durval S · Tulare, CAN59327Smith Steve W · Mackay, IDN5932AAquila Aviation LLC · Pompano Beach, FLN5932BAbsolute Altitude LLC · Buena Vista, CON5932ELockwood Shawn O · Volborg, MTN5932GBergen Henry E · Fond Du Lac, WIN5932JOwen Stephen M · Wiggins, MSN5932TSmith Jason M · Holland, PAN5933AWicklander Richard O · Spanaway, WAN5933BManier Byron K · Houston, MON5933EForsha Scott A · Cypress, TXN5934AJenkins Brian T · Batesville, INN5934BLlk Aviaiton LLC · Hanksville, UTN5934GDevils Lake Aero Repair Inc · Devils Lake, NDN5934RHoyt Jacob T · Oneida, NYN5935ADunn James Blair Jr · Bumpass, VAN5935GDeaero LLC · Darwin, MNN5935JSwinden Jonathan · Danville, PAN5935RStofer William B · Warsaw, INN5935TValley Wings Flight School LLC · Harlingen, TXN5936BTorrison Scott D · Chugiak, AKN5936EJensenius Danial P · Ray Twp, MIN5937FDodson International Parts Inc · Rantoul, KSN5937GD'Arge Ranyon Wc · Wilson, WYN5937RDavies Shane E · Kent, WAN5938ALand-O-Matics LLC · Wilmington, DE
Back to AD 79-10-14 R1