AD 98-21-21 R1
Registered aircraft · 85,612
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:98-21-21-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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.
N292MGGeorgia Aviation Authority · Eastman, GAN292MPRice Kendrick Q · Philadelphia, PAN292MWGroth Greg · Cookeville, TNN292NDChristiansen Aviation LLC · Wilmington, DEN292PASkywest Leasing Inc · St George, UTN292PZMalone Patrick A · Tuscumbia, ALN292REStructure Inc · Neenah, WIN292RMJunk Troy A · Wshngtn Ct Hs, OHN292WRabbitt Timothy N · Austin, TXN292WCColorado Mesa University · Grand Junction, CON29305Mbs Aircraft Inc · Saginaw, MIN2930BMcdougall Angus D · Gillette, WYN2930DGuerin Stephen · Lyme, NHN2930EKelly Ronald T Jr · Munhall, PAN2930FWrucke Scott · Horicon, WIN2930LSantana Maria M · Pearland, TXN2930QL A B Flying Service Inc · Renton, WAN2930RSouthern Warriors International Inc · Port Saint Lucie, FLN2930UWeast Michael D · Artesia, NMN2930VDale Aviation Inc · Rapid City, SDN29310Talbert James D · Alamogordo, NMN2931AStrategic Aircraft Management LLC · Fairbanks, AKN2931BMake It So LLC · Knoxville, TNN2931EHoward Charles O · Sonoma, CAN2931LPlanesmen LLC · Liberal, KSN2931MNsain Flight Ops LLC · Fort Worth, TXN2931QSky Dasher Inc · Wilmington, DEN2931ULudwig Alfred R · Hayward, CAN2931YWiesner Norman P Trustee · Silverton, ORN2932AHenderson Steven A · Idaho Falls, IDN2932DDont Make Things Difficult LLC · Downers Grove, ILN2932FIceman Holdings LLC · Greer, SCN2932LBcs Aviation LLC · Dothan, ALN2932QK & W Aviation LLC · Jackson, TNN2933AFlying Particles Inc · Livermore, CAN2933CLawson Matt E · Gobles, MIN2933FLevinsohn Reuben D · East Lansing, MIN2933QThomas Mark E · Corpus Christi, TXN2933VJones David T · Las Vegas, NVN2934ADixon Devin M · Las Vegas, NVN2934CPolte Steven J · Knoxville, TNN2934DHennis Jess L · Cottonwood, IDN2934FH & S Aviation LLC · Roseville, MNN2934ULison Denis Gregory · Hollis, NHN2934YOwens John A · Granville, OHN29359Cervantes Jose DBA · San Diego, CAN2935CSuez Jose F · Tracy, CAN2935DMorris Mark A · Westlake, TXN2935FPeirce Brenden D · Eatonville, WAN2935GWilliams Herbert B Jr · Pensacola, FL
Back to AD 98-21-21 R1