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.
N9081JPerkins Jimmy Keith · Lonoke, ARN9081LReed William B Trustee · San Jose, CAN9081VSale Reported · Phoenix, AZSale reportedN90829Leading Edge Aviation Consultants LLC · Windsor, CTN9082DLeahy Garry E · Van Wert, IAN9082LSmethurst Jeffrey C · San Francisco, CAN90839White Jake W · San Antonio, TXN9083BNorth Coast Flight School Inc · Meadville, PAN9083DSachs Randy S · S Huntington, NYN9083KShuey Robert D III · Albertville, ALN9083LPeavy Michael J · Chico, CAN9084FIsland Bound LLC · Dunedin, FLN9084VLinear Air LLC · Herriman, UTN9085JBligh Michelle C · Oceanside, CAN9085KSale Reported · Grayling, MISale reportedN9085LBlanton Jeffrey D · Valley Center, KSN9086DDarrow John K · Soldotna, AKN9086JBrogan William J · Port Matilda, PAN9086KMedia Stew LLC · Carson City, NVN90874Myers Brian R · South Bend, INN90878Schmoll Steven D · Zimmerman, MNN9087DBolden Family Farms · Little Rock, ARN9087LDeterding Jim L · Pond Creek, OKN9088Sale Reported · Manvel, TXSale reportedN90882Bucciarelli Dominick F · Pueblo, CON9088DMetro Aircraft Co · Bloomington, MNN9088JRiggins Ryan W · Durango, CON9088LLegends LLC · Willow, AKN9088QGolf Foxtrot Yankee LLC · Kingston, NYN9088TSlykerman John A · Bakersfield, CAN90898Nation Steven R · Hurricane, UTN9089CCrew Sourcing Inc · Wilmington, DEN9089HDavis Joseph S · Andalusia, ALN908AArcher Aero LLC · Wilmington, DEN908AFRobinson Craig M · Colfax, CAN908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN908AZWingsleasing LLC · Wichita, KSN908BLBoudreaux Jacques P · Shreveport, LAN908CPCivil Air Patrol Inc · Maxwell Afb, ALN908DRRhodes Dennis R · Taylorsville, GAN908JDNash Gregg Lynn · New Waverly, TXN908NDUniversity Of North Dakota · Grand Forks, NDN908QCCook Hugh Q · Aurora, CON908SCGomez Ryan Rene · Fort Worth, TXN908TBushby Harvey M · Minooka, ILN908WAPea-Wayman Flight LLC · Daytona Beach, FLN90908Charles Wilford W · Big Lake, AKN9090BHaynes Aviation LLC · Wetumpka, ALN9090LBascue Brandon D · Ward, ARFirst renewal noticeN90912Snead Douglas A · Derby, KS
Back to AD 90-04-06 R1