AD 2007-24-13
Registered aircraft · 4,026
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:2007-24-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:2007-24-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:2007-24-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:2007-24-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.
N652MHCirrus Aviation Services LLC · Colorado Springs, CON652TBCirrus Design Corp · Duluth, MNN653BWSmall Frank · Collegedale, TNN653DENippert Dwight A · Lancaster, OHN653DGWatson Dallas C · Guthrie, OKN653KS653 Kilo Sierra LLC · Palm Springs, CAN654CDCharlie Delta Aviation LLC · Sheridan, WYN654JRCapital Holdings 233 LLC · Fullerton, CAN654KBDonatti Fernando E · Katy, TXN654LCCirrus Bay Partners LLC · Naples, FLN654MCD Andrea Victor Brian · White Rock, NMN654MFPenair LLC · Monroe, LAN655CDCrh Services Inc · Shreveport, LAN656CDAec Ally Equipment Company Inc · Murray, UTN656REPlane And Simple Inc · Sunrise Beach, MON656SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN656TWAnderson Leif Knut · Sidney, MTN657MDLevangie Randall James Trustee · Yulee, FLN657MWWaddell Mark E · New York, NYN658CKCke LLC · Dover, DEN658TAJse Aviation Operations LLC · Watertown, NYN6593MCirreus Flyers LLC · Baltimore, MDN659CCMammolink LLC · New Port Richey, FLN659JKnier & Associates Inc · Cary, NCN659RMattyair LLC · Holbrook, NYN65HLMurphy Air LLC · Pine Bluff, ARN65KBBurke Daniel P · Oyster Bay, NYN65LKLift Enterprise LLC · Helena, MTN65TYMbessette LLC · West Ossipee, NHN661CD15wg LLC · Mobile, ALN661CZCirrus Design Corp · Duluth, MNN661SRCirrus 22 LLC · Woodbury, CTN663CDCirrus Sr22 1847 Inc · Wilmington, DEN663KKQualitair LLC Trustee · MichelstadtN66411Cirrus Design Corp · Duluth, MNN664TT4mediation LLC · Lake Wales, FLN665CWAmro Air LLC · Folsom, CAN665DMCyclone Aviation LLC · Macedonia, IAN666AJN666aj Inc Trustee · Wilmington, DEN666FUTouch N Go Gnv LLC · Alachua, FLFirst renewal noticeN666KDAircraft Guaranty Corp Trustee · Oklahoma City, OKN667CDCirrus Aircraft Shares Inc · Williamsburg, VAN667CWRegistered aircraftN667SRN667sr LLC · Richmond, KYN668RSRs 238 LLC · Long Beach, NYN668SRLatitude Aviation LLC · Huntingdon Valley, PAN669CDNo Fear Services LLC · Madison, WIN669MAN669ma Inc Trustee · Wilmington, DEN66JEUer LLC · Searcy, ARN66LJ66lj Flying LLC · Wilmington, DE
Back to AD 2007-24-13