AD 99-05-13 R1 WD
Registered aircraft · 13,518
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:99-05-13-R1-WD')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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.
N936SIrving Holdings LLC · Greensboro, NCN936SAHalpin Cuyler · Lewisville, TXN936VN936v LLC · Knoxville, TNN936WDCorporate Velocity Inc · Pawleys Island, SCN9370HRath Aviation Services LLC · Spearfish, SDN9370QS & L Skyview Aviation LLC · Wilmington, DEN9370SSheehan Robert K · Edmond, OKN9371QAshe Industries LLC · Murrieta, CAN9371SRiley Loy D · Charlton, MAN9373SCentral Vermont Flying Club Inc · Williston, VTN9375YNord Aviation Inc · Santa Teresa, NMN9377YReiland Andrew W · Boaz, ALN9379QSale Reported · Pottsboro, TXSale reportedN937DJBank Of Utah Trustee · Salt Lake City, UTN937VNabarrette Angel · Odessa, TXN937WB7wb LLC · Middletown, DEN9380QRegistered aircraftN9381YGlotzer Steven H · Scottsdale, AZN9387YGiordano James J · Livonia, MIN938BDB And M Aircraft Inc · Wilmington, DEN938QBowers Enterprises LLC · Peachtree City, GAN938VParlin Troy W · Wills Point, TXN9393QD5167 LLC · Kalispell, MTN9399YMorgan Charles R · Shelbyville, INN93APGill Paul E · Port Saint Lucie, FLN93JDDocmax LLC · Tucson, AZN93MSTwin Bo Safety LLC · Griffin, GAN93MTJ2 Sky LLC · Encinitas, CAN93TSky Masters Inc · Bonner Springs, KSN93VTLidner Mark H · Sun City, AZN9400QPrealow Scottie T · Lubbock, TXN9401YRoper Eric William Andrade · Henderson, NVN9405HInternational Air Services Inc Trustee · Carson City, NVN9405SHackbarth Dean R · Henderson, NVN9406SMorales Harry · Hilton Head Island, SCN9407SRobinett Barton L · Frankston, TXN9409YHamre Jeffrey · Leonard, NDFirst renewal noticeN940RLaw Offices Of Ray S Jones Psc · Pikeville, KYN940ZBMcbee Harvey Edward III · College Station, TXN9410SMoore James F · Higden, ARN9410YCapital Framing LLC · Greensburg, KYN9412SSamels Randy · Simi Valley, CAN9415QMichael D Scott · Los Gatos, CAN9415SWasson-Ece Instrumentation · Fort Collins, CON9415YRizzuti Robert T · Theodosia, MON9416SAllen Roger B · Gardnerville, NVN9416YSneed John A · Fort Morgan, CON9417YRegistration Pending · Decatur, TXRegistration pendingN9418QBonanza Partners LLC · Taos Ski Valley, NMN9418YEnloe Robert J Jr · Naples, FL
Back to AD 99-05-13 R1 WD