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.
N7808VWalker Trenton A · Pittsburg, OKN7808YKleiner Daniel S · Aliso Viejo, CAN7808ZWiedeman Matthew A · Batesville, INN78095Leuer James A · Encinitas, CAN7809GHodge Aviation LLC · Monroe, LAN7809NUninsured Justice Enterprises LLC · Joplin, MON7809SJo Ann Miller Marshall · Atlanta, GAN7809WHand Lawrence E · Klamath Falls, ORN780ACSouthern Aircraft Consultancy Inc Trustee · Casper, WYN780BGMaw Enterprises USA LLC · Hudson, FLN780DAFawley Dean · Newnan, GAN780DMTexas Barnstormers LLC · Rogers, TXN780GAPrairie Planes LLC · Mitchell, SDN780GWSchreiber-Beck Cynthia K · Wahpeton, NDN780KGGronewald Kenneth R · Hysham, MTN780LAN780la LLC · Philadelphia, PAN780NWBarthold David Keith · Gainesville, TXN780SN780s LLC · Williamstown, NJN780UOhio University · Albany, OHN780ZAGreat Lakes Belle LLC · Furlong, PAN7810DPetro Jerry R · Williamsburg, VAN78110Fries Tyler · Kenai, AKN78112Botnick Eric L · Luling, LAN7811BThomason David C · Olathe, KSN7811DGardner Thomas R · Summerville, SCN7811HCatto Air LLC · Jackson, CAN7811SCrop Air LLC · Eaton, CON7811VRivard Jayme · Monterey, CAN78123Rrr3 LLC · Midway, FLN78124Barrow James L · Elizabethtown, KYN78126Orme Jason R · Red Oak, IAN7812NSwaz Aviation LLC · Mesa, AZN7812VStorrud Jerrel T · Corvallis, MTN7812WSidner Jeffrey Paul · Colorado Springs, CON78130Garoutte Kirk E · Anchorage, AKN78139Van Straten Patrick F · Shiocton, WIN7813DBurkhart Galen L · Portland, ORFirst renewal noticeN7813HBevan John E · Spokane, WAFirst renewal noticeN7813WMnt Aviation LLC · Fairmont, WVN78142Partyka Kenneth M · Circle Pines, MNN7814ASchmidt Philip E · Weatherford, OKN7814MMenefee Michael · Bremerton, WAN7814NBynum Robert Austin II · San Antonio, TXN7814VBewley Terry V · Longview, TXN78150Dreyer Elwain C · Cardington, OHN78158Hill Donald J · Godfrey, ILN7815FBrammer Bryon L · Simi Valley, CAN7815GNextgen Flight Academy Inc · Riverside, CAN7815NSmall World Aero Solutions LLC · Belton, TXN7815VApice James M · Port Orange, FL
Back to AD 90-04-06 R1