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.
N412BPMission Hardward Ltd Co · Savannah, GAN412BSN412bs LLC · Southport, CTN412CAAirswiss Inc · Wilmington, DEN412CGBlue Sky Naples LLC · Naples, FLN412CKAir Blair LLC · Hubbard, OHN412CPSevern Aviation LLC · Richmond, VAN412CRRegistered aircraftN412DJStringfield Lisa P · Los Alamos, NMN412JJSkybird Aviation LLC · Bowling Green, KYN412MFCirrus Design Corp · Duluth, MNN412MSLfg Aviation LLC · Crossville, TNN412PABulletproof Asset Holdings LLC · Bradenton, FLN412PGVisual Approach LLC · Vienna, VAN412SRHealing Waters Counseling Center LLC · Cedar Bluff, VAN412TKBaerresen Drake A · Corona, CAN412WDColumbia Asset Trust Corp Trustee · Wichita, KSN412YZLegacy Air Group LLC · Palm City, FLN4134SQualitair LLC Trustee · MichelstadtN4135TNehls Chevrolet Olds Cadillac · Marshall, TXN4137CN4137c Inc · Redwood City, CAN413ACJibber Aviation LLC · Westfield, MAN413AKAlhambra Aviation LLC · San Mateo, CAN413APAba Aviation LLC · Northbrook, ILN413BMLee Aviation LLC · Sheridan, ARN413CNOa2 Aviation LLC · Gallatin, TNN413CPDean Taylor LLC · Palm Coast, FLN413EM413em LLC · Columbia, ILN413JDJwd Aviation LLC · Johns Creek, GAN413KJHuber Jeffrey C · Sidney, OHN413MP413 Aviation LLC · Washington, PAN413PTag Aviation LLC · Larwill, INN413RSStewart Rentals LLC · Tampa, FLN413SRBroussard Knoll Law Firm LLC · Marksville, LAN413TLSnapper Kai LLC · Kerrville, TXN413WMCirrus Design Corp · Duluth, MNN413WWWilkinson Jason S · Eastvale, CAN4140GCaribbean Development Partnership Ltd · Wilmington, DEN4141TPremier Properties And Investments LLC · Tarkio, MON4141XSpuddy Properties LLC · Leclaire, IAN4146APinpoint Investment Capital Inc · Healdsburg, CAN4148GKutrieb Wolfgang Michael · Chetek, WIN414ACBirman Pablo · Suamico, WIN414AFSano Aviation Corp · Lewes, DEN414AKValiair Lc Trustee · Casper, WYN414AMToucan Aviation LLC · Lafayette, LAN414AQQualitair LLC Trustee · MichelstadtN414ARFlight Med LLC · Cumming, GAN414ASRobertson Julianne · Los Osos, CAN414ATCreekmore Arnold · Somerset, KYN414AVChoate Oilfield Services LLC · Hennessey, OK
Back to AD 2012-10-13