AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeN34VMRoberts Glenn T · Port Orange, FLN34WEWildes Thomas O · Chippewa Falls, WIN34WGWings Of Grace Inc · Vonore, TNN34WWChute Aviation LLC · Prescott, AZN350ABierlein Aviation LLC · Midland, MIN350BLAustin Neal · Fort Myers, FLN350BTAeroventure LLC · Middletown, DEN350CWPrivate Flight LLC · Wilmington, DEN350DGQualitair LLC Trustee · MichelstadtN350ELCowick Glen M · Hollister, CAN350FJHafer Randall Frederick · Marietta, GAN350GMCannonball Trucking Inc · Houston, TXN350LCDaly Arthur P · El Paso, TXN350PGGuerra Michael E · Kerrville, TXN350RPShy Dennis · Cape Coral, FLN350SFTakamatsu Hiroaki · Redmond, WAN350SLNeenair LLC · Danville, VAN351ABTropical Transport Services Ltd · San Juan, PRN351CDRegistered aircraftN351HCBig Elk Aviation LLC · Elk City, OKN351JPParker Robert · Oklahoma City, OKN351PKK-Air Inc · Egg Harbor, WIN351SREagle I LLC · Kalispell, MTN351TWLlorca5 LLC · Bradenton, FLN351VKFly Amelia LLC · Montclair, NJN352JAPeterson Erik · Zeeland, MIN352JSMccormick Kevin · Douglass, TXN352KPN258wt LLC · Boca Raton, FLN352MBD&D Aviation LLC · Brandon, MSN352MMWindmill Aviation LLC · Sleepy Hollow, NYN352MRN352mr LLC · Weldona, CON352QWingstodieu LLC · Charlotte, NCN352RCN352rc Inc Trustee · Wilmington, DEN352SRGulf Atlantic Airways Inc · Gainesville, FLN352TImpact Aviation LLC · Ballwin, MON352TSBoss Contract Services LLC · Terry, MTN352WTTinkerbell Holdings LLC · Tavares, FLN353Giddings Thomas C · Fort Myers, FLN353CDSt Croix Leasing LLC · Fredonia, WIN353GGrady Seamus Trustee · Pleasanton, CAN353KSReichard Leasing LLC · Harrisburg, PAN353PGDecarlo Rick P · Minden, NVN353TCook Thedra K · Peachtree City, GAN35443Registered aircraftN354BCChamberlain Donald H · Ooltewah, TNN354BWCarpenter Richard A · Hermiston, ORN354EMSrm Aviation Solutions LLC · Richland, WAN354FCBlue Sky November LLC · Mamaroneck, NYN354SNKenmore Crew Leasing Inc Trustee · Bellingham, WA
Back to AD 2012-10-13