AD 96-10-01 R1
Registered aircraft · 8,139
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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.
N56704Anderson Aviation LLC · Wadesboro, NCFirst renewal noticeN56705Syrek William · Erie, PAN5670UNelson Bros Farms · Hector, MNN56713Vaillancourt Marc H · Milford, MAN56714Richman Martin S Trustee · Leawood, KSN56717Hp Flight Service LLC · San Antonio, TXN56723Sewell David J · Largo, FLN56724Marianas Air Transfer Inc · Tinian, MPN5672UWatson Phillip J · Jackson, TNN56734Hales Michael G · Farwell, MIN56736N56736 LLC · Fort Smith, ARN56748Cutler Matthew · Santa Clarita, CAN5674WJimenez Marcos A · Little Ferry, NJN56750Williams Nicholas E K · Stacy, MNFirst renewal noticeN56756Morley Thomas O · Riverside, CAN5675WAmmons Benjamin W Jr · Jacksonville, FLN5676UMg Aviation · Oshkosh, WIN56771Haight Robert A · East Haven, CTN5677UGolden Age Aviation LLC · Naperville, ILN5677WLangel Brandon · Saint Charles, MON56783Dennerline Rhett R · Northfield, ILN56788Osgood Aaron · Glen Mills, PAN5678UPaul William R · Oconomowoc, WIN5678WMckinney Douglas Andrew · Hastings, MNN5679UInverted Holdings LLC · Newnan, GAN56809Hudak Susanne Marie · Gold Canyon, AZN5680WGoines Courtnee J · Jacksonville, FLN56821Cowlin Aviation LLC · Houston, TXN56828Gillette Daniel R · Chillicothe, ILN5682WRiggin Flight Service Inc · Madison, SDN5683WYanta Chris · Rockport, TXN5684WSeverino Racli · Closter, NJN5685UTres Amigos Flying Club LLC · Redding, CAN5685WRempel Steven P · Prague, OKN56861Wingsleasing LLC · Wichita, KSN5686UHobbs Stanley T · Middleburg, FLN5686WPromedical Inc · Pfafftown, NCN56887Leavitt Teyvin M · Coeur D Alene, IDN5688WSerendipity Rentals LLC · Denver, CON56898Evans Katrina · Watkinsville, GAN5689UGeorge Marc J · Harker Heights, TXN568FLAir Ventures Flying School LLC · Smithfield, RIN568WACarver Clarence K Trustee · Lutz, FLN56902G R Martin & Associates LLC · West Plains, MON5690UPena Flight Partners LLC · Oakland, CAN5690WSaunders Sean D · Smyrna, TNN5692WFollmer Harvey C III · Trout Run, PAN56943Mcdowell David M · El Cajon, CAN5694UPlencner Robert E · Round Lake Beach, ILN5694WLange James R · Tempe, AZ
Back to AD 96-10-01 R1