AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N425SWGratitude Unlimited LLC · Reno, NVN425WMRegistered aircraftN4264CMmc Properties LLC · Cottonwood, AZN426AC21 Holdings LLC · Southlake, TXN426BGZulu Golf LLC · Henderson, NVN426BLRice Developments LLC · Walker, LAN426DJNehoc Leasing LLC · Marietta, GAN426GWNottingham Holdings LLC · Bluffton, SCN426LJVenture Air Solutions Inc · Opa Locka, FLN426MMcmahan Aviation LLC · Hattiesburg, MSN426SHDesert Stellar Aviation LLC · Phoenix, AZN426SRSchoeneman Michael D · Central Point, ORN426TDJuliet Tango Aviation Inc Trustee · Wilmington, DEN426WULucy In The Sky LLC · Los Angeles, CAN426WVAbhrdh Enterprises LLC · Bunker Hill, WVN4272CKamps Air LLC · Grand Rapids, MIN427ARDouglass Aviation LLC · Franktown, CON427ATMockingbird LLC · Bloomington, INN427BDNostra Aeris LLC · Gassville, ARN427CEVwd Aviation LLC · Bozeman, MTN427CWRural Orthopedic Care LLC · Ardmore, OKN427DWFlyin Phar LLC · Salt Lake City, UTN427JRWhite James L · Belleair, FLN427JTCirrus Design Corp · Duluth, MNN427KDRegistered aircraftN427KGWhite James J IV · Conroe, TXN427SRTrosclair Air LLC · Gonzales, LAN427TXMayfly Holdings LLC · Monticello, FLN427YECavu Capital LLC · Concord, NCN4282PAero Tramp Holdings LLC · Dallas, TXN4287AWilliam Dolson And Associates LLC · Santa Fe, NMN428AJetpropmontana LLC · Cameron, MTN428AMT G Mendell Corp · New York, NYN428ANPatriot Flyers LLC · Lake Havasu City, AZN428APPaper Plane Aviation LLC · Sharpsburg, GAN428ESPbjd Aviation LLC · Henderson, NVN428SRLautman Karl F Trustee · Los Angeles, CAN428TLight Korbin T · Midland, TXN428TMBlue Jay Omni Bearing LLC · Fargo, NDN428WSSquires Wayne M · Corpus Christi, TXN428ZZDeans List Aviation LLC · Nashville, TNN4298YAir LLC · Fresno, CAN429CDQualitair LLC Trustee · MichelstadtN429KRK Air LLC · Indianapolis, INN429PDupuy William C · Waco, TXN429PSMjk Leasing LLC · San Antonio, TXN429RCN429rc LLC · Gladwyne, PAN429SRN205bp LLC · Sheridan, WYN42ACirrus Design Corp · Duluth, MNN42AAN42aa LLC · Nantucket, MA
Back to AD 2012-10-13