AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N133DXWeaver Michael J Trustee · Rancho Santa Fe, CAN133FCWisdom Blake Andrew · Chapmansboro, TNN133HSGrover Ronald D · Justin, TXN133JDSwick James N · Celina, TXN133KBIsland Time Aviation LLC · Peachtree City, GAN133KCDiggins David A · Corpus Christi, TXN133NO'Brien Daniel R · Naples, FLN133PJAmerican Liquid Concentration Operations LLC · Lewes, DEN133PRJamian Corporation · Lewes, DEN133PSBrew City Acro LLC · Milwaukee, WIN133RPPowers Ronald A · Hudson, WIN133RVBraun Danial R · Damascus, ORN133TMT1 Aerospace Inc · Wilmington, DEN133UOrion Future Data LLC · Sarasota, FLN133WCRegistration Pending · Huntingdon, TNRegistration pendingN1340JHenry Loren M · Fairhope, ALN1340WJohnson Jon · El Paso, TXN1340ZLogue Andrew Douglas Trustee · Port Saint Lucie, FLN13411Leiss Todd J · Merritt Island, FLN1341TShuman Cecil R Trustee · Chugiak, AKN1341ZAustin Bill DBA · Sparta, TNN1342HRobertson James P Trustee · Templeton, CAN1342TCrewdawg Aviation LLC · Concord, NCN1342UBell Scott A · Mc Alpin, FLN13430Mjr Assoc LLC · Bend, ORN1343TWestern Cherokee Six LLC · Fort Collins, CON1343WInfinity Aviation LLC · Piedmont, SDN1344HConner W Larry · Los Lunas, NMN1344WVortex Aviation LLC · Biloxi, MSN13454Parry Matthew J · Oxnard, CAN1345HNelson Chester C · Little Falls, MNN1345WHendricks John E · Heber Springs, ARN13468Wanner Kevin M · Morristown, NJN1346JWinston James R · Cornelius, NCN1346TNortham Thaddeus R · Mckinney, TXN1346WUnal Alper Cevat · Las Vegas, NVN1347THagan William Jackson · Wetumpka, ALN13484Aero-Flite Corp · Murfreesboro, TNN1348LFlight World Inc · San Juan, PRN13493Pelaez Gilberto · Chatsworth, CAN1349TMjl Flyers LLC · Somerset, PAN134ACSkyline Solutions Inc · Deland, FLN134BChristiansen Aviation LLC · Wilmington, DEN134BWRussell Schwendiman Farms Inc · Ririe, IDN134CCParrott Chad D · Powderly, TXN134CHTeke Elevate LLC · San Antonio, TXN134CPHoughton Lewis · Waxhaw, NCN134DBBlue Skies27 LLC · Los Angeles, CAN134DCCranton Larry J · Mesa, AZN134FCDepartment Of Agric & Consumer Svc/S · Tallahassee, FL
Back to AD 2006-10-21