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.
N6428VDodson International Parts Inc · Rantoul, KSN6428WGeraghty John T · Long Beach, CAN64291Price Kellous A · College Station, TXN64294Eagle Sky Patrol Inc · Deadwood, SDN64296Olmstead Clyde M · Fenton, MIN64297Uptegraff Roy E III · Mc Kees Rocks, PAN64299Hawk Flying Club · Caledonia, MIN6429LMcpherson Joshua R · Oviedo, FLN6429VScott Dean A · Winchester, VAN6429WFarquharson Mark · Hampton, VAN642AWHobart Aviation Inc · Akron, OHN642AZHanson Jake Anthony · Loma Rica, CAN642BMEngel Bradley K · Hillsboro, ORN642DGTubular Products Of Texas Inc · Tomball, TXN642FTFlorida Institute Of Technology · Melbourne, FLN642FWSharpe Thomas W · Asheboro, NCN642GDFitzpatrick Timothy Jr · Yerington, NVN642JAYale Companies LLC DBA · Indianapolis, INN642LEMason County Aero Club · Ludington, MIN642MDSkydog Aviation LLC · Gainesville, GAN642PSHamer Steven R · Eagle, IDN642RN642r LLC · Farmland, INN642RKKellar Robert J Trustee · Woodbridge, CAN642RSRomeo Sierra Aviation LLC · Sparks, NVN642RVGitlin Joshua · Truckee, CAN642SAFlying Time Llp · Fort Mill, SCN642SBBloomberg David C · Northampton, MAN642SPBlue Sky Aviation Association Inc · Readington, NJN642TXKenney Mark S · Channahon, ILN642TZBensen John A · Greenville, NYN642WPValiair Lc Trustee · Casper, WYN642WZMap Enterprises Inc · Mayfield, KYN64301B&R Aircraft LLC · Wadsworth, OHN64302Lanehart Zachary · Keo, ARN64303Acey Services LLC · Cumming, GAN64305Skyhaven Flying Club Inc · Dover, NHN64307Flywyo LLC · Kalispell, MTN64308Rein Robert G · Seattle, WAN64309Sveta Kadirova · Louisville, KYFirst renewal noticeN6430LSale Reported · Maysville, KYSale reportedN6430QMellor James F · Spanish Fork, UTN6430UWallace Dale E · Edison, NJN6431Cussen George J · Mount Prospect, ILN64313Aerial Scouting Solutions LLC · Sioux Center, IAN64314Registration Pending · New Bern, NCRegistration pendingN64317Spernak Airways Inc · Anchorage, AKFirst renewal noticeN6431CBarclay William G · Peyton, CON6431QTruitt John M · Fishers, INN6431RCarothers Paul W · Russellville, ARN64325Varney Aviation LLC · Bangor, ME
Back to AD 90-04-06 R1