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.
N3581WCloud Richard D · Lafayette, LAN3584WSeek Stephen E · Valles Mines, MON3585WRodriquez Nat III · Odessa, TXN3589WCfi Aero LLC · Riverside, CAN358BTRorabaugh Kenneth P · Sunrise, FLN3590WAgoston Thomas M Trustee · Liberty Twp, OHN3592WFoothills Aviation Inc · Pickens, SCN3593WGriffin Julie A · Locust Grove, GAN3594JWxs Flying LLC · Mesa, AZN3595WStanley Shawn G · Lorton, VAN3596WAbdelqader Hamza Faris · Beaufort, SCN3598WSwiss Eagles Inc · Las Vegas, NVN35CWTimoney James M · Auburn, MEN3601WPrecision Landings Inc · Wilmington, DEN3602WJeswald Joseph M · Buffalo, NYN3607WOceanstate Flying Club Inc · Little Compton, RIN3608WHand Andy A · Waco, TXN3609WConverse James Robert · Port Saint Lucie, FLN3612WKard Aviation LLC · Greenville, SCN3613WTurner Travis · Chetek, WIN361RPRocha Aviation LLC · Prescott Valley, AZN3620WSemler Jason M · Cambridge, MNN3629WFly Code Repeat LLC · Lewes, DEN3630WScarborough Robert T · Yuma, AZN3634WCarey Nicholas Isaac · Clarkston, WAN3635WSwieter Avionics LLC · Waverly, IAN36361Smith Robert Ervin III · Mountain Top, PAN36364Gordon Security Solutions LLC · Chester Springs, PAN3637WStruck Dennis L · Spirit Lake, IAN3638WCherokee Six LLC · Williamson, GAN3639WYoungpeter David L · Spencerville, OHN363RCWilliams Eric S · Miami, FLN3641MSweet Water Air LLC · Kissimmee, FLN3641WMitchell Jeffrey Scott · Donalsonville, GAN3642WMasia Matt D · Paso Robles, CAN36440Aircraft Guaranty Corp Trustee · Oklahoma City, OKN3645WDodson International Parts Inc · Rantoul, KSN3646WWap Air LLC · Newburgh, INN3647WNichols Robert H Jr · Normandy, TNN3649WTurbo Six LLC · Wilmington, DEN364MCLesser Antilles Corp Trustee · Wilmington, DEN3651WTraxler Christopher V · Russia, OHN3652WValiair Limited Co Trustee · Casper, WYN3656WNuvision Heaqlth Center · Macomb, MIN3658WFlying 20 Club Inc · Springfield, ILN36615Booth Warren Russell · Doylestown, PAN3661WPrete Vincent A · Jim Thorpe, PAN3664WSuffoletto Gregory · Hamburg, NYN3665WWitham Chris · Cathedral City, CAN3669WDocken Marvin O · Omaha, NE
Back to AD 74-18-13