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.
N660TAReinhardt Anthony C · Duchesne, UTN660TMPeacock Quarry L · Post Falls, IDN6610Seyour Lori L · Woodstock, GAN6610JSaracoff Norman L · Neillsville, WIN6610PBarr Merlin A · Clarinda, IAN6610UTreichler Peter DBA · East Aurora, NYN6610WHattersley Donald C · York, SCN66111Cutlass 661 LLC · Orange Park, FLN6611DMoralli Joseph · Chico, CAN6611PSelect Charities LLC · Spokane, WAN6611UVan Koevering Dennis Jay · Hudsonville, MIN6611WBryant Bryce Nicholas · Crothersville, INN6612LSwanson Thomas J · Pukwana, SDN6612RCourtney David P · Reedsport, ORN6612UGiem James L · Coupeville, WAN6612VEverman Terry Jay · Vassar, MIN6613H6613 H Ltd · Wilmington, DEN6613RPollazzi Steven N · New Hope, PAN6613WBanks Jeffrey G · Columbus, OHN6614UVanderford Kenneth W · Fort Worth, TXN6614VThomas Anna D · Kiana, AKN6615DCivil Air Patrol Inc · Montgomery, ALN6615JAeropenn Aviation Academy LLC · Paxinos, PAN6615UDobos Lester J · Bordentown, NJN6615WLoughridge Steven L · Montezuma, OHN66168C P Aviation · Santa Paula, CAN6616DMjng Investment Group LLC · Melbourne, FLN6616HBurke Anthony · Poughkeepsie, NYN6616JBrack Enterprises LLC · Indianapolis, INN6616PMorrison Austin · Statesville, NCN6616RVanover Kevin · Whitesburg, KYN6617ELinstad Daniel Elmer · Canby, ORN6617HNorth Franklin County Flying Club · North Lawrence, NYN6617JJeffries Holdings LLC · Bargersville, INN66189Skynick Enterprises Inc · Tarzana, CAN6618DStein Air LLC · New Ringgold, PAN6618PChurchill John C · Parker, AZN6618VLang Gerald K · Baker, MTN6618WLe Ariya · La Crosse, WIN6619DBannwart Justin S · North Liberty, INN6619JBjelland Nathan D · Phoenix, AZN6619PRatliff Byron L · Paragould, ARN6619ULucas Jolie Candace · Pismo Beach, CAN661CCMarkey John J Jr · Aurora, ILN661CPSouthern Aircraft Consultnacy Inc Trustee · Casper, WYN661DJRadley Larry L · Universal City, TXN661FLS B Enterprise LLC · Marshall, TXN661FTFlorida Institute Of Technology Inc · Melbourne, FLN661JCKruse Thomas S · Mena, ARN661JPEvans Craig A · Irvine, CA
Back to AD 90-04-06 R1