AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N7977BG&M Aircraft Inc · Wheat Ridge, CON79FYManaj Aviation LLC · Wilmington, OHN79NCLiam Clerkin Inc · Wilmington, DEN79PXOcerg Holdings LLC · Springdale, PAN7FMAppalachian Racing Aviation LLC · Johnson City, TNN7SXBennett Mark A · Markleville, INN8018CPatterson Charles A · Springfield, OHN8088BRegistered aircraftN808DLSons Aviation Inc · Moody, ALN8097CImmell Michael · Buffalo, OKN8099VGrannetino Gerald F · West Chester, PAN80BRN80br LLC · Port Orange, FLN810MJCampbell Fred Cox · Monroe, NCN81223Eat Aviation LLC · Metter, GAN8127KAntler Aviation And Wildlife Service LLC · Wasilla, AKN812WMApopka Aero Club LLC · Winter Garden, FLN81305Wadsworth Robert M · Wellesley, MAN8133SWoodard David · San Diego, CAN8137DLee'S Mobile Service Inc · Holt, MON8137HLimitless Horizons Sevierville LLC · Seveirville, TNN8144ABrickbat Aviation LLC · Little Rock, ARN8144YAnderson John R · Belgrade, MNN8147JSt Rogers Holdings LLC · El Paso, TXN8160AKasw Aviation LLC · Warsaw, INN8185CKirkland Kerry G · Spring, TXN818AHChandler Jerome P · Redondo Beach, CAN81LMMission Flight Academy · Yucaipa, CAN8203CKoelsch Seed LLC · St John, KSN825RDFrank Richard · West Dundee, ILN828LBBeraut Olivier Trustee · Scotts Valley, CAN8314CR M W LLC · Florence, SCN833GSHogan John A · Florence, SCN8367CBuckwalter Daniel E · Homer, AKN840WMKunzelmann Christopher E · Weatogue, CTN841ADCedar Real Estate Inc · Anaheim, CAN8424CD And A Enterprises LLC · Wilmington, DEN8440FMarsh John E · Washington, DCN8485FGoff Mark A · Hot Springs, ARN84EBHodge Joseph Randall · Brenham, TXN8502NDickman Edward A · Melba, IDN8509CMaxwell Samuel L · Wasilla, AKN851VLBlue Waters Air Charters LLC · San Juan, PRN852VLBlue Waters Air Charters LLC · San Juan, PRN853VLBlue Waters Air Charters LLC · San Juan, PRN854VLBlue Waters Air Charters LLC · San Juan, PRN8577CWaldmiller Robert Joseph · Rosamond, CAN8587TJet Winds LLC · Gulf Shores, ALN85CTAerobsession LLC · Erie, CON8600NCen-Tex Wings LLC · Cedar Park, TXN8601NLpm Sky Masters LLC · Green Cove Springs, FL
Back to AD 74-18-13