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.
N813BDD & D Airpark LLC · Anchorage, AKN813CNAtp Aircraft 7 LLC · Wilmington, DEN813CTDoolley Flyers LLC · Harvard, MAN813DCJ & J Aviation Holdings LLC · Dallas, TXN813DZPlett Conrad · Paden, OKN813JWComanche Air Inc · Tacoma, WAFirst renewal noticeN813KMSantopietro Paul · Dunnellon, FLN813PBunn Dennis E · Wilson, NCN813SCFf22 LLC · Scottsdale, AZN813SMWalicke Michael T · New Port Richey, FLN813SSLake In The Hills Aviation LLC · Algonquin, ILN813THHolliday Terry C · Chugiak, AKN813WHOwens Waylon D · Pacific, WAN813WKTinney Michael · Piedmont, ALN8140CMenier Robert · Milltown, WIN8140DMckellar John T · Hamburg, NYN8140JGreen Rick A · Hudson, IAN8141CHoff Fredrick · Twin Falls, IDN8141DCasper Glen · Garden City, KSN8141KKezele William A · Idaho Falls, IDN8141WParham Randy L · Saint Charles, MON8141ZFbni Inc · Oakland, MDN8142Hostetler Craig L · Glendive, MTN81425Pegasus Copters LLC · Makawao, HIN8142DMontague Mark W · Reno, NVN8142EAbourezk Michael C · Rapid City, SDN8142HC & T Aviation Holdings Inc · Mckinney, TXN8142JGriffith Charles · Santa Maria, CAN8142KHesseltine Robert J · Grand Terrace, CAN8142LWesellairplanes Com Inc · Wilmington, DEN8142YGarner Charles E · Sitka, AKN8143BBeauchamp Joshua Kane · Denton, NCN8143CNazelrod Eric V · Washington, OKN8143ECadet Air Corps Museum · Tarkio, MON8143HHahn Jeffrey L · Whitewater, WIN8143P8143 Leasing LLC · Manassas, VAN8143WMartell Ryan · Madison Heights, VAN8143YTennave LLC · Dublin, OHN81441Thomas Ramone O · Philadelphia, PAN8144CMusgrove Stacy J · Cunningham, TXN8145COlson Caden · Billings, MTN8145DJindra Russell L · Glennallen, AKN8145PRegistered aircraftN8145VAscend Aviation LLC · Bountiful, UTN8145WNagel Thomas H · Tiffin, OHN81465Cornia Robert W · Long Beach, CAN8146AQuinn James F · Canton, MAFirst renewal noticeN8146CClark David A · Plainfield, INN8146WKemp Terry L · Lowell, ARN8147WFirst Landings Aviation LLC · Apopka, FL
Back to AD 90-04-06 R1