AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N517SHHelme Stanley B · Lodi, CAN517SMMcelvain Pete R · Iowa Park, TXN517VBBoudro Vernon G · Greenview, CAN517WCFreedom Wings LLC · Parker, CON517WDAmundson Lee R · Chatfield, MNN51807Maniscalco Peter · Germansville, PAN5180BRoberts Toney K · Batesville, MSN5180LGrogan Timothy · Bradenton, FLN5180RMacdonald Kaitlyn · Dillon, MTN5180XSouthern Sky Holdings LLC · Macon, GAN5180ZScheer Paul G · Portland, ORN51810Jones David L · Powderly, TXN5181HRegistered aircraftN5181REdelen Daniel R · Clayton, NCN5181SHicks Douglas A · Cumming, GAN5181TSchmetter Kenneth E · Needville, TXN5181WSzymanski Janet M · Alanson, MIN5181XKummer Nicolas · Wenatchee, WAN5182ERegistered aircraftN5182LGarden City Aviation LLC · Augusta, GAN5182SFoster Tyler R · Levelland, TXN5183HLlewellyn John M · Grangeville, IDN5183LWolstenholme Robert F · Line Lexington, PAN5183MGc Aviation Services 1 LLC · Miamisburg, OHN5183PAig Aeronautics LLC · Guaynabo, PRN5183RThompson Aerial Service Inc · Wyndmere, NDN5183SWestland Aviation LLC · Lake Havasu City, AZN5183TMinier Tryg · Corralitos, CAN5183XStory James W · Byhalia, MSN51840Sky Bubble LLC · Santa Ana, CAN51846Magnum Aviation LLC · Goff, KSN5184EStringfellow Timothy C · Maryville, TNN5184HReynolds Michael A · Fairbanks, AKN5184JRiverside Flight Academy LLC · Riverside, CAN5184LOtt Timothy M · Ida, MIN5184S1st Cooling Inc · Rockwall, TXN5184XComstock Derrick B · Salol, MNN5184ZCox Ronnie · Whitesburg, GAN51850Hendrickson Flying Service Inc · Rochelle, ILN51851Brothers Aviation LLC · Black Rock, ARN51859Barr Andrew B · Beulah, MSN5185DMartinez Richard Christian · Stockbridge, MIN5185QRegistered aircraftN5185TRomano Serge · Beaverton, ORN5185ZTroy Michael J · Albion, NYN51863Green Wendell L · Argyle, TXN51865Savage Michael B · Lincoln, CAN5186HPope Brian B · Coalgate, OKN5186LKlippel Charlie L · Huntington Beach, CAN5186WQuick Janice L · Wrightwood, CA
Back to AD 90-04-06 R1