AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N26896Magnus Air Ct LLC · Manchester, CTN26899Gibson Daniel W · San Marcos, TXN2689CColvin Clu DBA · Big Cabin, OKN2689DRegistration Pending · Greenwood, MSRegistration pendingN2689GShandog Air LLC · Ashland, KYN2689JFinley Taylor J · Colby, KSN2689QKirschke John K · Seneca Falls, NYN2689RMortensen Mark S · Hamilton, MTN2689WLocke Timothy S · Fort Irwin, CAN268AFApogee Flight Inc · Bellingham, WAN268BGHuff Holdings LLC · Ashland, KYN268BHJett Cory L · Floyds Knobs, INN268CDKahng Jim · Torrance, CAN268CPCivil Air Patrol · Maxwell Afb, ALN268CRMaxcy Christopher L · Bozeman, MTN268CSInternational Air Services Inc Trustee · Carson City, NVN268CTCoast Flight Training And Management Inc · San Diego, CAN268DASpartan Education LLC · Tulsa, OKN268DLCrenshaw Robert L · Goldsboro, NCN268DMRobinson Michael E · Chandler, AZN268EPEpic Aviation Inc · Denison, TXN268FMRunamuck LLC · New Orleans, LAN268JCShaw Melvin · Annapolis, MDN268JGSpero Bruce A · Carson City, NVN268MAMasters Of The Air LLC · Salt Lake City, UTN268MCRegistered aircraftN268MERegistered aircraftN268MGGeorgia Aviation Authority · Eastman, GAN268PBeaulot LLC · East Aurora, NYN268RKalhart Transportation Services Inc · Rancho Santa Fe, CAN268RJHudson David A · Jonesboro, ARN268RVRegistered aircraftN268SStrohmeyer Charles R II · Lancaster, OHN268SAInarayan Inc · Winter Park, FLN268TZHague Robert A · Rogers, ARN268YMilton Quincy N · Bellevue, WAN268ZMewmew Investment II LLC · Palo Alto, CAN26907Registered aircraftN2690AHamons Jeffery W · Perrysburg, OHN2690CEdwards Zachary · Sylmar, CAN2690FStephenson Casey H · Assaria, KSN2690GFerkin Air LLC · Caldwell, IDN2690JDodson International Parts Inc · Rantoul, KSN2690QSilva Alberto · Titusville, FLN2690RSchleck Scott A · West Concord, MNN2690TN633at LLC · Punta Gorda, FLN2690YSmith Joshua B · Kenai, AKN26913Alto Vista Flying Club · Cupertino, CAN26915Doolittle Dean M · Bandera, TXN26917Nebrig Kenneth J Trustee · Prescott, AZ
Back to AD 2007-04-19 R1