AD 96-12-03 R2
Registered aircraft · 164
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-12-03-R2')
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-12-03-R2')
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-12-03-R2') 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-12-03-R2') 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.
N2JDHauf Daniel Ray · Jack, ALN300FAIcenogle Roger A · Inver Grove, MNN300WDPlane Fun Inc Tr Trustee · Snellville, GAN311PSRegistered aircraftN31PMEverything Pitts LLC · Queen Creek, AZN31WKKing Wesley A · Los Angeles, CAN320PSCtaerocraft LLC · Lexington, NCN321MCAerospace Trust Management LLC Trustee · Wilmington, DEN331JRLeclercq Benoit B · Saint Cloud, FLN340PSPowell Lester E Jr · Savannah, GAN345DWAir Research Ca Inc · Torrance, CAN35PJKucel R Scott · Dallas, TXN36MTLesko Brady · Lusby, MDN388PSDarrow Matthew J · Truckee, CAN41ACPitts Flying Club Of Stoughton · Stoughton, WIN427ZRCampbell Glen R · Phoenix, AZN42TWDavis Keith · Manchester, TNN434DMSmith Lester C Jr · Colleyville, TXN450GMMyers Shawn Lee · Rincon, GAN466YYSmith Brent A · Macomb, ILN48BTMalone William · Mount Nebo, WVN48EWKucel Richard S · Dallas, TXN49315Morphew Ben · Mckinney, TXN49331Plane Fun Inc Tr Trustee · Snellville, GAN49335Van Cleave Raymond D · Kalispell, MTN49336Krieger Heinz Friedrich · FrenkendorfN49338Bakker Matthew G · Ellington, CTN494BEBig Ego Aerobatics Inc · Naperville, ILN49BROlmsted Aviation LLC · Santa Paula, CAN49LHTexas Pitts Partners LLC · Plano, TXN50ALCardon Benjamin P · Chubbuck, IDN514BDLepkowski Daniel P · Industry, PAN51HCVelarides Paul · Litchfield Park, AZN51PCCox James M · Holly Pond, ALN51STCnc Aerobatics LLC · Ada, MIN524MDStick N Rudder LLC · Kensington, NHN5327CTolleson Charles B Jr · Carpentersville, ILN5344JMark Aero LLC · League City, TXN5349XBegrow Adroaldo Dorivaldo · Gulf Shores, ALN5352EEvergreen Aviation & Space Museum & Captian · Mcminnville, ORN53LMEastern Stearman Inc Trustee · Leesburg, VAN555RLBorek Thomas J · Homestead, FLN56KLAircraft Partner Holdings Inc Trustee · BerlinN56PSLeonard Paul N · Ewa Beach, HIN58CTS 1t LLC · Parkland, FLN58DERichmond P Curt · Anna, TXN597TJJt Airshows · Slidell, TXN59KKWhite Pitts Inc · Wilmington, DEN5SGMaxwell Edward · Louisville, KYN6025LThille Nicholas M · San Luis Obispo, CA
Back to AD 96-12-03 R2