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.
N8384HTwin Tier Aviation Association Inc · Eldred, PAN8384WWilt Jared C · Marysville, OHN8385LKrebs Lisa Christine · Homer, AKN8385WJohnson Robert J · Floral City, FLN8385YNesbitt Loyd B Jr · Independence, ORN8386C86 Charlie LLC · Rochester, MNN8386LAdams Haidyn · Pentwater, MIN8387CRuday Dennis J DBA · Glendora, CAN8387JCallison Patrick L · Hazel Green, ALN8387LSerra Christopher R · Snellville, GAN8387RMiloud Chadd K · Fort Worth, TXN8387VN8387v LLC · Lansing, MIN8387WHolt Zachary Ian · Bogalusa, LAN8387YN8387y LLC · Huntsville, ALN83882Warrior 83882 LLC · Dover, DEN8388AHamm Simon P · Denali, AKN8388RFloyd James · Gainesville, TXN8388WWatts Timothy S · Denver, NCN8388YInternational Air Services Inc Trustee · Carson City, NVN83896Clifford Aviation LLC · Delta, CON8389AJacobus Larry E · Ipava, ILN8389EBymers Robert F · Waunakee, WIN8389LJkg LLC · Murfreesboro, TNN8389VNelzen Wayne K · Mulino, ORN8389WStegemoller Ronald G · Washington, TXN838AJsl Air LLC · Sikeston, MON838CFCherokee Flyers Inc · Vero Beach, FLN838DHGcbc LLC · Norman, OKN838JWFleming Cheri Rene · Joseph, ORN838KPKapa International · Santa Monica, CAN838MACca Aero Estate LLC · Missoula, MTN838MBFreischlag Karl A · Fort Collins, CON838MPWhitney Stephen · Fort Myers, FLN838PProfessional Training Aircraft LLC · Wilmington, DEN838PCGadamic LLC · Fresno, CAN838SShaw James J · Loranger, LAN838SPEdb Air Inc · Wilsonville, ORN838TStandard Jacob R · Lakeway, TXN8390CArserio Gregory J · Fairport, NYN8390LBliss Marketing Communications Inc · Phoenix, AZN8390VMapel Roger N · Weirton, WVN8390WLong Joseph · Mint Hill, NCN83914Upstate Aviators LLC · Spartanburg, SCN8391MConner Jason M · Moses Lake, WAN8391QGambel E Anthony · Sewanee, TNN8391SVip Medical Services LLC · Nixa, MON8391VRoflyco Ltd · Glendale, AZN8391WNavara Cole J · Ulster Park, NYN8391YSchafer Gary L · Greenwood, DEN8392YTwinco Flyers LLC · Powell, OH
Back to AD 90-04-06 R1