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.
N7478Hubbard Matthew L · Phoenix, AZN747ASRooks Peter L · Andover, MAN747CTN747ct LLC · Mayfield, KYN747CWDynamic Engineering Inc · Van Buren, ARN747DVUnrestricted Climb LLC · Muskego, WIN747DWAviation Trust Company LLC Trustee · Oklahoma City, OKN747GLoblolly Management LLC · Concord, NCN747LJEichleay Peter · Yarmouth, MEN747LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN747MBMaitland Egerton M Jr Dr · Lexington, SCN747MCCirrus Sr22t Mmc 2285 Inc Trustee · Wilmington, DEN747PHFirst State Bancshares Inc · Middleberg, KYFirst renewal noticeN747PJOsprey Capital LLC · Winston Salem, NCN747PLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN747SBCloud Transport Operations LLC · Kalispell, MTN747SDAvitrans Inc · Cypress, CAN747SJBuell Steven M · Fisherville, KYN747SLWesley Kelley · Pontotoc, MSN747SWJet Air Inc · Iowa City, IAN747TGValiair Ltd Co Trustee · Casper, WYN747TTDogbolter Aviation LLC · Milwaukee, WIN747VPSavfar Aviation Inc · Wilmington, DEN747WSHyannis Air Service Inc · Hyannis, MAN747YVGreat Among The Nations Inc · Beverly Hills, CAN7485QEvans Charles H Trustee · Hooksett, NHN748CDPinkgg LLC · Marathon, FLN748CMFox Creek Aviation LLC · Los Gatos, CAN748DCHorizon Products LLC · Las Vegas, NVN748JARegistration Pending · Phoenix, AZRegistration pendingN748MGEl Paso Aero Inc · El Paso, TXN749BSPropeller Aircraft Holdings LLC · Everett, WAN749CDGoat Island Films Inc · Covina, CAN749JBSkylands Group LLC · Wilmington, DEN749PGSfly LLC · Dubuque, IAN749RBAdams Aviation Services Inc Trustee · Wilmington, DEN749RCChadwick Michael · Reston, VAN749SPNew York State Police · Latham, NYN74AGMarion Pilots Club Inc · Marion, INN74BRBbj Aviators LLC · Springfield, ILN74BYMav & Merlin Aviation LLC · Columbia, SCN74CRCage Presnall C · Falfurrias, TXN74CWN74cw LLC · Sandy, UTN74DTEnjoy Life Flying LLC · Sunrise, FLN74DXKendrick Jeffrey Joseph II · Hayden Lake, IDN74ESValiair Ltd Co Trustee · Casper, WYN74FBBurns Fred J · Hampstead, NCN74FXGeorgia Screen Rooms LLC · Wilmington, DEN74GPPapa Tango LLC · Sioux Falls, SDN74HJRegistration Pending · Sheridan, WYRegistration pendingN74KVAerodhooth Kilo-Victor LLC · Acton, MA
Back to AD 2012-10-13