AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7606JLiburd Edison V · Austell, GAN7606KAmmons Curtis D · Hernando, MSN7606WOlsen Michael D · Woodinville, WAN7607EPowerbelt LLC · Glendale, CAN7607FRolinski Alexander S · Deland, FLN7607GOwens Wilbur · Rch Palos Vrd, CAN7607JMoser Robert W · Flower Mound, TXN7607LMeyer Maria S · New Fairfield, CTN7607RScott Mark G Jr · Manvel, TXN7607WZero Seven Whiskey LLC · Dewey, OKN7608FAj Mush LLC · Dearborn, MIN7608HKavanagh Preston B · Tarpon Springs, FLN7608JGevry Ronald Joseph Jr · Alpharetta, GAN7608YJohnson Craig · Moreland, GAN7609DBraden James L · Hillsboro, KSN7609FKomberec Eric R · Kalispell, MTN7609JMcmaster William Timothy · Hanford, CAN7609KShrode Rafe C · Jewett, TXN7609YDowning Gregg R · Guymon, OKN760AAce Aircraft Leasing Inc · Nazareth, PAN760BWBridgewater State University · Bridgewater, MAN760CPCivil Air Patrol · Maxwell Afb, ALN760FSModi Yogini · Homestead, FLN760JATextron Aviation Inc · Wichita, KSN760JKFly Buys Inc · Wilmington, DEN760JMTibbetts Harrison J · Santa Rosa, CAN760LADna Flight LLC · Hillsboro, ORN760MASandpiper Air LLC · Elizabeth City, NCN760UOhio University · Albany, OHN760WParagon Airplane Leasing Co · Fort Myers, FLN7610DBug Smashers LLC · Winfield, KSN7610GFalconer Robert H · Yolo, CAN7610JDelci Dino J · Tempe, AZN7610PMorris Scott R · Steilacoom, WAN7610WMeier Michael D · Naubinway, MIN7610XShezifi Mathew · Livermore, CAN7611BCason Thaddeus D · Polk City, FLN7611DLazare Luke B · Merrill, WIN7611FGeneral Aviation Support Corp · Rosamond, CAN7611GStaunton Curtis J · Tulelake, CAN7611HVezina Robert J · Rockford, MIN7611LSteils Building Renovation And Management Inc · Lino Lakes, MNN7611PChamberlain Paul E · Troup, TXN7611USchmitt Matthew A · Kenosha, WIN7611WRace Place Inc · Greenwood, INN7611YRandall Dean A · Reno, NVN7611ZKnutson Wayne R · Tioga, NDN7612GSwartwood Thomas C · Everson, WAN7612JSpeer Aviation LLC · Live Oak, FLN7612RSamper Aviation LLC · Easton, PA
Back to AD 81-18-04 R2