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.
N65561Wisconsin Aviation Inc · Watertown, WIN65563Darcy Aviation LLC · Danbury, CTN6556BLewis Joseph M · Huntington Beach, CAFirst renewal noticeN6556HRyco LLC · Lusk, WYN6556JJabco Inc · Weston, IDN6556UQoc Innovations LLC · Fall River, WIN6556WMontagnino James A · Saratoga Springs, NYN65572Rucinski Edward A · Climax, NCN6557HRiverside Flight Academy LLC · Riverside, CAN6557JAsd LLC · Lebanon, NJN6557UAtalla Mark S · Woodford, VAN6557WFrederick Darin L · Star, IDN65582Curley Keron P · Rockaway Park, NYN65583Meridian Airport Authority · Meridian, MSN65584G And M Aircraft Inc · Wheat Ridge, CON65586Sunstate Aviation Inc · Kissimmee, FLN65587Wings Over Texas Holdings LLC · Denton, TXN6558JKarr Dennis R · Clyde, OHN6558UReed Gina D · Starkville, MSN6558WShirley Hills Aviation LLC · Macon, GAN65592Cohen Frederick I Trustee · Tulsa, OKN6559WHarrison Michael W DBA · Lewisville, IDN655AStrough Jacob L · Twin Falls, IDN655ACAuxier David R · Baker City, ORN655AGSkywest Leasing Inc · St George, UTN655CLRomuald David L · Newnan, GAN655DKSkovbjerg Jorgen · Angwin, CAN655HEStyers Bret A · Wasilla, AKN655MAFanning John F · Delaware, OHN655NArtemis Aviation Group LLC · Kalispell, MTN655NPPanasenko Nicholas · Machesney Park, ILN655PDJls Aviation LLC · Sarasota, FLN655RVMartin David M · Port Saint Lucie, FLN655SMcclellan George M · Salem, ORN655SKMassey Roger L Trustee · Nipomo, CAN65609Leland Robert · Ft Wayne, INN6560NVano Sally L · Carlos, MNN6560RBurgett William J · Juneau, AKN6560UTeaford Kris K · Berryville, VAN6560WBeaunaux John-Daniel S · Graham, WAN6560ZPiper Aviation Museum Foundation · Lock Haven, PAN65610Flying Vikings Inc · Hayward, CAN65613Christiansen Aviation LLC · Wilmington, DEN65614American Patrols Inc · Midland, TXN65619Registration Pending · Long Beach, CARegistration pendingN6561JKyode Inc · Creswell, ORN6561LCentral Mississippi Aircraft LLC · Hickory, MSN6561QChristiansen Aviation LLC · Wilmington, DEN6561UJones Charles · Mountain Grove, MON6561WAnderson Vance K · Eugene, OR
Back to AD 90-04-06 R1