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.
N556BKd Helicopters Inc · Shingleton, MIN556CDSec Ventures LLC · St Charles, ILN556CTWilliamson Terry W Jr · Pratt, KSN556DBSr Holding And Investment LLC · Wilmington, DEN556ERSunrise Aviation Inc · Ormond Beach, FLN556FLKarg Asset Management LLC · Pocahontas, ARN556GGooch Joel L · Sumter, SCN556JRSemmig Jeffrey C · Oceanside, CAN556KRWhitaker Robert M · Richfield, UTN556LInternational Air Services Inc Trustee · Carson City, NVN556LGEgmond Aircraft LLC · Lewes, DEN556MKurdzel Mark A · Chattanooga, TNN556NDRainier Flight Service LLC · Renton, WAN556PAAviator Corp · Wilmington, DEN556PCChristiansen Aviation LLC · Wilmington, DEN556PSPotter Mark W · Portland, ORN556RJHastings Rick Joe · San Antonio, TXN556RMMorrison Robert J · Rock Hill, SCN556RVKetter Ralph J · La Luz, NMN556RWEhrlich Randall V · Greenwich, CTN556SCSpartan Education LLC · Tulsa, OKN556SHNovember Alpha LLC · Dover, DEN556SPTexas State Technical College · Waco, TXN556WCDassel James T · San Juan Bautista, CAN556WHRobert L Stephens · Argyle, TXN55700Curry Edwin A · Pearland, TXN55701Level Up Aviation LLC · Newton, ALN55702Seay Horace M · Desoto, TXN55706Camp Justin P · Edwall, WAN5570BDavis Lucas · Kennewick, WAN5570DFletcher Jerry W · Yuma, AZN5570FCherokee Adventure Corp · Wilmington, DEN5570MFlythebat.Com LLC · Chicago, ILN5570URegistration Pending · Mesa, AZRegistration pendingN55711To Ivan K · Auburndale, FLN55715Ricker Alexander · Spur, TXN55716Norby Aviation LLC · Hopkinton, MAN55719Coffey County Airport · Burlington, KSN5571CHarrison Steven D · Rolla, MON5571DReuland Robert C · West Windsor, VTN5571JHildebrandt Eric A · Cocoa, FLN5571MEdwards Larry N · Saint Joseph, MON5571PDaube Timothy B · Hampton, VAN5571QBerry Charles P · Monroe, NCN5571VColeman Douglas E · Tallahassee, FLN55722Cactus Aero LLC · Haslet, TXN55724Parker David G · Bristol, TNN55726Diedeman Thomas A · Lake City, FLN5572BOrcutt David R · Greenleaf, IDN5572UPoor Farmer Aviation LLC · Saint Marys, OH
Back to AD 2007-04-19 R1