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.
N44VVHampton Warrior II Inc · Shelter Island, NYN44VWVan Wagnen Brian J · Jackson, MIN44WBEvans Jerry R · York, PAN44WCWhite Eagle Investments LLC · San Jose, CAN44WDDemray William S · Northville, MIN44WERedman Harvey E · Lapeer, MIN44WKMaiden Robert M · Williamson, GAN44WLLitton Wade N · Townsend, MTN44WMBloomfield Robert C · Anchorage, AKN44WPAnderson Stuart R Jr · Sahuarita, AZN44WTMoore Arlon A · Newcastle, CAN44WZWild Blue Yonder LLC · Batavia, OHN44XDDuffer David · Fallbrook, CAN44YGAppelt Jon A · Dayton, NVN44YTJohs Robert W · Palacios, TXN44YUDoane Mica S · Meno, OKN44YYYankee LLC · Kasilof, AKN44ZCMarker Michael M Jr · Los Lunas, NMN44ZWTurner Robert H · San Diego, CAN4500RWork Edward · Sneads Ferry, NCN4500WMagalsky Jacob J · Wilsall, MTN4500ZBielefeld James L · Kenai, AKN45018Cook Randal J · Newland, NCN4501EOptima Aviation LLC DBA · Lewisville, TXN4501HBrown Kevin · San Dimas, CAN4501JBleem Steven L · Duncan, OKN4501RNess James H · Phoenix, AZN4502ZBoyer Bruce A · Toledo, OHN45035Knutson Family Limited Partnership 2 · Chetek, WIN4503JSkykid Adventures LLC · Cedar Valley, UTN4503YSteppler Dean M · Culbertson, MTN4504YCronin Monty A · Gettysburg, SDN4505ASteadman Norman W · Arlington, TXN4505RFayal Kenneth E Jr · Bend, ORN4505YGeneral Air Service LLC · Van Wert, OHN45060Stone Eric · Cedarpines Park, CAN4506APennsylvania College Of Technology · Williamsport, PAN4506MBig Bend Community College · Moses Lake, WAN4506RCruz Roberto Jr · Douglasville, GAN4506TPettit Kenneth W · Madison, INN4506VRegistered aircraftN4507JSkvara Stanley Henry Jr · Parma, OHN4507NGarnet Aviation LLC · Fort Worth, TXN4507QFrost Aviation Services Inc · Las Cruces, NMN4507RFly First LLC · West Memphis, ARN4507TLoma Aviation LLC · San Diego, CAN4507XVanny Ravy · Winchester, CAN45086Dahl Ken L · Granite Falls, MNN4508ABonogofsky Thomas L · Bridger, MTN4508JWood Daniel W · Cottonwood Shores, TX
Back to AD 90-04-06 R1